A order by issue

From: sreejith (sreejithsreejith_at_yahoo.com)
Date: 03/24/04 

Date: Tue, 23 Mar 2004 21:36:06 -0800

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

Relevant Pages

  • Re: File Download Save vs Open
    ... AumHa VSOP & Admin; DTS-L.org ... When I click on the docment on www, File Download ... When I choose OPEN the file it is saved in Temp folder ... as a .tmp file and opened in MS Word, but then I am trying to Sent To ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Insert into Table, Max Value from the Same Table
    ... 'Admin' ... 'Super' ... I know I can get around this using temp ... tables and IDENTITY columns, but unfortunately I can't use identity ...
    (microsoft.public.sqlserver.programming)
  • Re: administrator password
    ... Jupiter Jones [MVP] ... "kittcha" wrote in message ... > A temp has been into our office and changed the admin ...
    (microsoft.public.security)