Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
Add spaces in between concatenate statement
lauren brown
Feb 16 2011 10:39 PM
9.2k
Reply
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! :)
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
Help Me!!!!!
If Else Statement not working