Lower « String Functions « SQL Server / T-SQL






1.LOWER: Translates all characters within the string to lower case
2.Combine Lower() Upper() and substring() function to capital the first letter in a word