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
correct is select upper(convert(location using latin1)) as location from MemberLocation;
It works fine also the first option.(A)
Except A all other solutions don’t work in my system
A
But the A option doesn’t show any differences in the data. So it doesn’t convert the data to upper letters. Any ideas?
An the B option works for me the same as the A option