SQL Letter Case Conversion Function UPPER (), UCASE (), LOWER (), and LCASE()

SQL letter case conversion functions UPPER(s), UCASE (s), LOWER (s), and LCASE (s)

1, LOWER(s) function and LCASE(s) function

The LOWER(s) or LCASE(s) function can convert all letter characters in string s into lowercase letters.

Instance:

Use the LOWER function or the LCASE function to convert all letter characters in a string to lowercase. The SQL statement is as follows:

SELECT LOWER('WWW.W3Cschool.cn'),LCASE('W3CSCHOOL.CN');

The results are as follows:

2, UPPER(s) function and UCAS (s) function

SELECT UPPER('www.w3cschool.cn'),UCASE('W3Cschool');

No matter which function you use, it doesn't make much difference, so you can select a function to use as needed