关于包含字符'-'的ORDER BY问题

关于包含字符'-'的ORDER BY问题

表里有以下三条数据，字段COL的类型为nvarchar(100)。
eBusiness Consultant
E-business Manager
eBusiness Specialist

如果ORDER BY COL，则返回
eBusiness Consultant
E-business Manager
eBusiness Specialist

如果ORDER BY CONVERT(varchar(100),COL),则返回
E-business Manager
eBusiness Consultant
eBusiness Specialist

看上去直接ORDER BY该字段的时候好像忽略了字符‘-’，不知道为什么？

不会忽略，按照字符的ASCII码排序，结果没问题：

SQL codeselect ascii('-'),ascii('b')

/*
----------- -----------
45          98
*/

SQL code
---------------------------------
--  Author: htl258(Tony)
--  Date  : 2009-07-09 18:53:28
---------------------------------
--> 生成测试数据表:tb

If not object_id('[tb]') is null
    Drop table [tb]
Go
Create table [tb]([col] varchar(100))
Insert tb
Select 'eBusiness-Consultant' union all
Select 'E-business-Manager' union all
Select 'eBusiness-Specialist'
Go
--Select * from tb

-->SQL查询如下:

select * from tb order by col
/*
col
----------------------------------------------------------------------------------------------------
eBusiness-Consultant
E-business-Manager
eBusiness-Specialist

(3 行受影响)
*/
select * from tb order by convert(varchar(100),col)
/*
col
----------------------------------------------------------------------------------------------------
eBusiness-Consultant
E-business-Manager
eBusiness-Specialist

(3 行受影响)
*/

select @@version
/*

---------------------------------------------------------------------------
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
    Oct 14 2005 00:33:37
    Copyright (c) 1988-2005 Microsoft Corporation
    Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

(1 行受影响)
*/