Posted by Simon Hayes on 10/01/80 11:19

"Duy Lam" <duylam@gmail.com> wrote in message
news:1119462033.433216.3880@f14g2000cwb.googlegroups.com...
> I'm using collation SQL_Latin1_General_CP1_CI_AS and I need to sort a
> varchar field. There are some elements, however, that I want to come
> AFTER any alphabetic characters. Is there any character that sorts
> after "Z"? In normal ASCII, there are various characters that would
> sort after "Z" (e.g. "~"), but I can't seem to figure out what the case
> would be in the SQL_Latin1_General_CP1_CI_AS collation. Any ideas?
>
> thanks,
> Duy Lam
>

Perhaps you can post a specific script to show what you want? Many
characters might sort after 'Z', as you said - maybe you should check out
ASCII(), CHAR(), UNICODE(), COLLATE and "Using Unicode Data" in Books
Online? If you can post something that others can copy and paste into Query
Analyzer, then there's a better chance that you'll get a useful answer.

http://www.aspfaq.com/etiquette.asp?id=5006

Simon

[Back to original message]