Function to turn small letters into capital letters

angelalpe · New User Joined: 22 Sep 2005 Posts: 32

exists any function to turn very small letters into capital letters?

Srihari Gonugunta · Posted: Mon Nov 17, 2008 4:55 pm

You can use UPPERCASE function.

enrico-sorichetti · Posted: Mon Nov 17, 2008 4:56 pm

or the string/char with a blanks/blank x'40'

angelalpe · New User Joined: 22 Sep 2005 Posts: 32

I have tried with uppercase and the compilation says to me that it is not a function builtin

enrico-sorichetti · Posted: Mon Nov 17, 2008 5:15 pm

Srihari Gonugunta · Posted: Mon Nov 17, 2008 6:13 pm

Angela,
You can use Translate in that case.

TRANSLATE( x,
'ABCDEFGHIJKLMNOPQRSTUVWXYZ',
'abcdefghijklmnopqrstuvwxyz' )