如何选择 所有那些 不是以 0 - 9 a - z A-Z 开头的数据 ???

[shclhs]

譬如：
Column1 Column2 Column3
&001 ... ... 选择
0001 ... ...
A001 ... ...
c001 ... ...
Z001 ... ...
@001 ... ... 选择
&001 ... ... 选择
A0$0 ... ...
测试 ... ... 选择

[昵称被占用了]

where 字段 not like '[0-9]%'
and 字段 not like '[a-z]%'

[paoluo]

try

Select * From TableName Where Column1 Not Like '[0-9,a-Z]%'

[laoliu666]

Select * From TableName Where Column1 Not Like '[0-9,a-Z]%'

[昵称被占用了]

or:

where 字段 like '[^0-9]%'
and 字段 like '[^a-z]%'

[paoluo]

Create Table TEST
(Column1 Nvarchar(100))
Insert TEST Select '&001'
Union All Select '0001'
Union All Select 'A001'
Union All Select 'c001'
Union All Select 'Z001'
Union All Select '@001'
Union All Select '&001'
Union All Select 'A0$0'
Union All Select N'测试'
GO
Select * From TEST Where Column1 Not Like '[0-9,a-Z]%'
GO
Drop Table TEST
--Result
/*
Column1
&001
@001
&001
测试
*/

[昵称被占用了]

可以这样
where 字段 like '[^0-9,a-z]%'