LOWER: Translates all characters within the string to lower case : Lower « String Functions « SQL Server / T-SQL

1. SQL Server / T-SQL
2. String Functions
3. Lower

LOWER: Translates all characters within the string to lower case

1> -- LOWER: Translates all characters within the string to lower case.
2>
3> DECLARE @LOWER_STRING CHAR(100)
4> SET @LOWER_STRING = "www.Java2s.com"
5>
6> SELECT LOWER(@LOWER_STRING)
7> GO

---------------------------------------------------------------------------
www.java2s.com

(1 rows affected)
1>
           
       

Related examples in the same category