January 7th, 2009
UPPER (chg. to upper case)
Posted by
admin in
I. ANSI String Scalar Functions
The UPPER function changes all characters to lower case. Case changes affect only letters. Spaces, numbers, special characters, and punctuation remain unchanged.
Format: UPPER(string)
Example: UPPER('What is THAT?')
Result: ‘WHAT IS THAT?’
> Access does not support UPPER. Instead it uses UCASE.
> DB2 and MySQL support UPPER as well as UCASE.
> Oracle, PostgreSQL, and SQL Server support UPPER.
Comments Off
