Formatting Text 1

[ITSmwong]

Just wondering if anyone knows how to replace a string to just capitalize the first character only.

For example if I have a string "john" is there a command that can change it to "John". I know there is a command called upper that can convert that to "JOHN".

Thanks.
Mike

 

[jimstarr]

Hi Mike,

Try PROPER().

Jim

 

[alvechurchdata]

But be aware that it doesn't do a good job on names like "O'Leary" or "IBM" The come out as "O'leary" and "Ibm" because PROPER blindly capitalises the first letter of each word.

Geoff Franklin

http://www.alvechurchdata.co.uk