I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the LOWER() function today. The LOWER() function takes a source string as input and returns a output string with all alpha characters converted to lower case. The following example converts the favorite movie title of mine to lower case.
1 2 |
-- Make my string lower case select lower('WIZARD OF OZ') as str_phrase |
1 2 3 4 5 6 |
output: str_phrase ------------ wizard of oz </span> |
One thing to always worry about when using TSQL functions is how will it react with empty strings or NULL values? Both empty strings and NULL values as…