Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rongrzywacz
Yak Posting Veteran
57 Posts |
 Posted - 2001-12-18 : 15:41:46
|
| We are using ss 7.0. The db is set to not differentiate betweeen upper and lower case data, however we are now receiving some client data where I need to be able to distinguish between 'ABC' and 'Abc' in a query for 1 particular field. Is there an easy way to do this?Thanks for any help!RGRon Grzywacz |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2001-12-18 : 15:44:02
|
| In SQL7, you might want to convert the strings to thier varbinary form (using CONVERT or CAST) and then compare.In SQL2K you could use the new COLLATE statement.--HTH,VyasCheck out my SQL Server site @http://vyaskn.tripod.com |
 |
|
|
|
|
|
upper and lower case data issues