06-02-2011 6:08 AM
Hi,
I am downloading excel from report program.
I can convert string to either uppercase or lowercase,but i need to convert the string like this as shown below,,,,
'SUBRHMANYAM' conver this name into
'Subrahmanyam'.
The first letter should be capital.
06-02-2011 6:25 AM
06-02-2011 7:08 AM
Hi,
You can try this.
va_text = 'subrahmanyam'.
TRANSLATE va_text+0(1) TO UPPER CASE.