December 30th, 2008
LOWER (chg. to lower case)
Posted by
admin in
I. ANSI String Scalar Functions
The LOWER function changes all characters to lower case. Case changes affect only letters. Spaces, numbers, special characters, and punctuation remain unchanged.
Format: LOWER(string)
Example: LOWER('Look at THAT!')
Result: ‘look at that!’
> Access does not support LOWER. Instead it uses LCASE.
> DB2, and MySQL, support LOWER as well as LCASE.
> Oracle, PostgreSQL, and SQL Server support LOWER.
