|
Hello i am using IBM db2. I have 2 columns in my table : PER_DAY (DECIMAL(10,2)) DESCP (VARCHAR) I want to concat the two columns in my query... For Ex: PER_DAY=0.5 DESCP='ABCDEFGHIJ' I want them to be displayed as 0.5-ABCDEFGHIJ I'm using IBM DB2.
(comments are locked)
|
|
I found it...I used concat(concat(rtrim(char(int(PER_DAY))), '.'), rtrim(right(char(PER_DAY - int(PER_DAY)), 3))) Well done on finding your answer, and thank you for posting it for other people having the same problem. Could you please mark the answer as 'accepted' in order that we can all see from the main page that your problem is resolved?
Aug 01 '11 at 12:40 AM
Dave_Green
(comments are locked)
|
Your answer
