Paul Hill wrote:
Hi Vince,
Checkout the COLLATE keyword.
You can do:
SELECT * FROM mytable WHERE COLLATE SQL_Latin1_General_CP1252_CS_AS
myfield = 'bla'
The CS_AS bit is important, CS = case sensitive. AS = accent sensitive
Thanks, Paul!
I had to mess with it a bit, but using your advice as a springboard, I
was able to make it work with the following. Thanks again!
SELECT distinct pmt_type COLLATE Latin1_General_CS_AS_KS_WS as pmt_type
FROM payments
order BY pmt_type
COLLATE Latin1_General_CS_AS_KS_WS ASC
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/51656a4a.70...@taconic.net
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
