Examine the structure and content of the MemberLocation table:
You want to have the field location returned in all letters (example: BERLIN).
Which query would you use?
A. SELECT UPPER (Location) as location FROM MemberLocation
B. SELECT UPPER (BINARY location) as location FROM MemberLocation
C. SELECT UPPER (location AS UPPER ) as location FROM Memberlocation
D. SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation
|
Download Printable PDF. VALID exam to help you PASS. |
 |
According to the MySQL Reference Manual page on String Functions:
UPPER() is ineffective when applied to binary strings (BINARY, VARBINARY, BLOB).
Is it possible your ADDRESS column has a BINARY, VARBINARY, or BLOB data type?
If it is you will need to convert the Binary String to an “ordinary” string. For example:
UPPER(CONVERT(ADDRESS USING latin1))