sql ²éѯ - MS-SQL Server / ÒÉÄÑÎÊÌâ

SQL 2000 ÖÐ,²éѯij¸ö×ֶεÄÖµÖеÚÒ»¸ö×ÖÊǺº×ÖµÄÓï¾äÈçºÎд?

---

SQL code:
where left(col,1)a like '[ß¹-咗]

---

'[ß¹-咗] ÊÇʲôÒâ˼?

---

SQL code:
--------------------SQL ServerÊý¾Ý¸ñʽ»¯¹¤¾ß-------------------
---------------------------------------------------------------
-- DESIGNER :happycell188(ϲϲ)
-- QQ :584738179
-- Development Tool :Microsoft Visual C++ 6.0 C Language
-- FUNCTION :CONVERT DATA TO T-SQL
---------------------------------------------------------------
-- Microsoft SQL Server 2005
-- Developer Edition on Microsoft Windows XP [°æ±¾ 5.1.2600]
---------------------------------------------------------------
---------------------------------------------------------------

use test
go
if object_id('test.dbo.tb') is not null drop table tb
-- ´´½¨Êý¾Ý±í
create table tb
(
id int,
name char(5)
)
go
--²åÈë²âÊÔÊý¾Ý
insert into tb select 1,'jone'
union all select 2,'ÀîËÄ'
union all select 3,'Lili'
union all select 4,'ÍõÎå'
go

select * from tb where ascii(left(ltrim(name),1))>127 or ascii(right(name,1))<0

/*
id name
---------------
2 ÀîËÄ
4 ÍõÎå

(2 ÐÐÊÜÓ°Ïì)
*/

---

ÒýÓÃ

SQL code
--------------------SQL Ser