Hello,

I believe I had the same need/problem and I found a solution using:

select * from myTable order by UPPER(myField) COLLATE SQL_Latin1_General_CP850_BIN

the trick of course is to use UPPER to achieve case-insensitivity and then to use a binary collation to get everything else in an ASCII order.

Cheers,