Return Uppercase Equivalent of Character Using SQL Function

The SQL function "UCASE" returns the result of the argument character expression after converting all the characters to uppercase. UCASE is identical to UPPER, but provides ODBC-compatible syntax. Below is a sample Select statement.
 
SYNTAX
UCASE ( char_expression )

EXAMPLE
SELECT * FROM CUSTOMERS
WHERE UCASE(COMPANYNAME) = 'SGD';