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 |
|
mtl777
Yak Posting Veteran
63 Posts |
 Posted - 2012-03-16 : 22:35:49
|
| The default collation in my SQL Server installation is SQL_Latin1_General_CP1_CI_AS. I would like it such that a tilde symbol (~) would be considered as "greater" than the letter Z. Currently, if I have "Zebra" and "~Alpha" in the Description field, the sort order will be:~AlphaZebraI would like the sort order to be:Zebra~AlphaWhat collation should I use to achieve this? Note: I still want it to be case insensitive and the only thing I want it to do is to treat the tilde (~) character as greater than the letter Z. I have tried the BIN option and it works but it's no longer case insensitive.Your help would be greatly appreciated. Thanks in advance! |
|
|
|
|
|
Help with Collation