I have a column in table (primary key) which has 2 rows:
'AAAA'
'~~~' in MMSQL 7.0 when i use select * from the table order by .... the
query result will be
'AAAA'
'~~~~'
but when I converted the database to SQL 2000 the result will return
'~~~~'
'AAAAA'.
I tried to change collations and sort order but no luck.

in SQL 7.0 when I type in sp_helpsort the Query return:
Character set = 1, iso_1
ISO 8859-1(Latin01) - Western European 8 - bit
character set.
Sort Order = 50, bin_ISO 8859-1 (Latin 1) character set characters, in order
Can anyone tell me how to correct the problem ?

Thanks

Hungle