UCASE not working on VARBINARY

[richardson]

Hi there,

I have to change some rows to be uppercase. I recently changed the column I'm trying to work with to VARBINARY because I'll need to support case sensitivity soon. Before I do that I need to make everything currently in this column uppercase, so:

Code

SELECT UPPER(patientID) AS pID FROM prescriptions WHERE something...gives me the expected results, but not in uppercase!

How to do it?
Any ideas? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[vikasrocks]

Case folding is not applicable to binary data. That statement should cause an error saying that the argument has an invalid data type.

You should use a character type and specify a case sensitive collation. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --