How to assign NULL to a veriable throgh TRANSLATE in PL/I
Posted: Thu Feb 11, 2010 9:35 am
Hi,
I want to replace value of a particular column with a NULL character, not space.
A = 50?th Anniversary.
B = TRANSLATE(A,'','?'); is converting the O/P as "50 th Anniversary".
A space is being inserted.
Output I want as A = 50th Anniversary
No space inbetween 50 and th.
Please guide me on this and let me know how to acheive it in TRANSLATE command.
Regards,
Biswa.
I want to replace value of a particular column with a NULL character, not space.
A = 50?th Anniversary.
B = TRANSLATE(A,'','?'); is converting the O/P as "50 th Anniversary".
A space is being inserted.
Output I want as A = 50th Anniversary
No space inbetween 50 and th.
Please guide me on this and let me know how to acheive it in TRANSLATE command.
Regards,
Biswa.