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 |
Robowski
Posting Yak Master
101 Posts |
Posted - 2013-04-17 : 07:27:56
|
Just more of a general question really, when ever I need to compare a field for a a difference in character case I.e if someone has entered something into table.column in lower case when it should have been upper I convert to varbinaryBut I vaguely remember reading something about you can change the collation of the string to also find this out?Anyone know/does this make sense?CheersRobbo |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
|
Robowski
Posting Yak Master
101 Posts |
Posted - 2013-04-17 : 08:45:55
|
thanks for the info, always good to know other ways! |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-04-18 : 02:35:03
|
quote: Originally posted by Robowski thanks for the info, always good to know other ways!
Welcome--Chandu |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|