Hi

Sort order 53 provides Uppercase Preference whereas 52 doesn't. However, after using sort order 53 I don't that happening.

for example,

create table test_sort ( c1 int, c2 varchar(10) )
go
insert into test_sort values ( 101,'test1')
insert into test_sort values ( 102,'test1')
insert into test_sort values ( 103,'Test1')
insert into test_sort values ( 104,'test1')
insert into test_sort values ( 105,'test1')
insert into test_sort values ( 106,'Test1')
go

On executing, select c2 from test_sort order by c2

I expected the following output,

Test1
Test1
test1
test1
test1
test1

but this doesn't happen.. Any idea..

Thx
\ Joe