Re: A order by issue

From: Jack Jackson (jacknospam_at_pebbleridge.com)
Date: 03/24/04 

Date: Tue, 23 Mar 2004 21:52:16 -0800

SQLServer has many possible sort orders. Look at SQL Server Help for
sort order or SQL collations.

On Tue, 23 Mar 2004 21:36:06 -0800, "sreejith"
<sreejithsreejith@yahoo.com> wrote:

>hi
>i'm using SQLServer, i've a table say temp with one field EmpName consider the values as
>{Emp1
>AScott
>admin
>
>when i write a select query like this:
>select * from temp order by EmpName Asc i expect the recordset to be
>
>AScott
>admin
>{Emp1
>
>just because the ascii of "{" is 123
>"A" is 65
>and "a" is 97
>
>but i get
>
>{Emp1
>AScott
>admin
>
>could any one suggest a resolution for this problem, thanks in advance