TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
lauren brown
NA
33
93.4k
Add spaces in between concatenate statement
Feb 16 2011 10:39 PM
Hi experts,
I would like to add a lot of spaces in between my concatenate sql statement, "STAFF_ID || ' ' || STAFF_NAME AS STAFF_INFO". Would you be able to teach me how to do that?
"SELECT STAFF_ID, STAFF_NAME, DEPT_CODE, STAFF_ID || ' ' || STAFF_NAME AS STAFF_INFO FROM STAFF_DEPARTMENT WHERE STAFF_ID LIKE '%" + Searcht + "%' OR STAFF_NAME LIKE '%" + Searcht + "%' ORDER BY STAFF_ID ASC";
Thanks a million! :)
Reply
Answers (
6
)
Help Me!!!!!
If Else Statement not working