6
Reply

Add spaces in between concatenate statement

lauren brown

lauren brown

Feb 16 2011 10:39 PM
9.2k
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! :)

Answers (6)