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...