on 05-06-2008 9:58 AM
hai how to convert text from uppercase to lowercase. and lowercase to uppercase.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
use TRANSLATE statement:
TRANSLATE <var> to UPPERCASE.
TRANSLATE <var> to LOWERCASE.
Regards,
Dara.
i got
data a(15) type c.
a = 'translation'.
to translate this to upper case
TRANSLATE A TO UPPER CASE.
Thanks
Use keyword TRANSLATE
Thnx,
satya.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.