recycled
Mr or Mrs. 500
Points: 579
More actions
December 30, 2003 at 12:43 pm
#81818
I need to sort text fields in an order like
AAAaaaBBBBbbbb. Is there a HEX function that I can use?
Allen Cui-55137
SSC Guru
Points: 51650
December 30, 2003 at 1:10 pm
#488259
You may add Collate to your statement like select country from customers order by country COLLATE SQL_Latin1_General_Cp1_CS_AS
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply