Well, these steps help reproduce the problem even with tsql utility 1> create table #tmp1 (i int, v varchar(10) collate Hebrew_CI_AI) 2> go 1> insert into #tmp1 values(1, cast(0xde05d905d305e205 as nvarchar(10))) 2> insert into #tmp1 values(2, cast(0x69006e0066006f00 as nvarchar(10))) 3> insert into #tmp1 values(3, cast(0xd805e705e105d805 as nvarchar(10))) 4> insert into #tmp1 values(4, cast(0xd005d105db05 as nvarchar(10))) 5> go 1> select * from #tmp1 2> go
also useful to try "select v,v from #tmp1 order by i" bye freddy77
smime.p7s
Description: S/MIME cryptographic signature
