How to add a space after each field value in SQL query job

maxsubrat · Active User Joined: 27 Feb 2008 Posts: 110 Location: india

Hi,

I have to fetch 3 column fields in a SQL and I want to put a space after each value. For ex:

SELECT A.EMPT, B.REC, B.DATE
FROM EMP A, STDC B

If I wish to run the above query in a IKJEFT job (not in SPUFI) and send the data to a file, the records are coming without any space after each value.. Like
INS120203866ACFBSMNS2012-01-21-13.21.35.042100

So I want to put a space in between. Like:
INS120203866 ACFBSMNS 2012-01-21-13.21.35.042100

Thanks

dbzTHEdinosauer · Posted: Thu Mar 01, 2012 11:54 am

GHU!

how about:

SELECT A.EMPT,' ', B.REC, ' '.B.DATE
FROM EMP A, STDC B

maxsubrat · Active User Joined: 27 Feb 2008 Posts: 110 Location: india

got it ! Thanks