UPPER/LOWER(x)
UPPER(x) and LOWER(x) are
string functions that convert a character string to uppercase/lowercase letters.|
Result of the UPPER(x) or LOWER(x) function | |
x is NULL value |
NULL value (see data type) |
Model table:
Refining searches by specifying uppercase/lowercase letters
SELECT * FROM hotel WHERE UPPER (name) = 'FLORA'
HNO |
NAME |
ZIP |
CITY |
ADDRESS |
30 |
Flora |
48153 |
New Jersey |
158 Gardiner Street |