譬如:
Column1 Column2 Column3
&001 ... ... 选择
0001 ... ...
A001 ... ...
c001 ... ...
Z001 ... ...
@001 ... ... 选择
&001 ... ... 选择
A0$0 ... ...
测试 ... ... 选择
Column1 Column2 Column3
&001 ... ... 选择
0001 ... ...
A001 ... ...
c001 ... ...
Z001 ... ...
@001 ... ... 选择
&001 ... ... 选择
A0$0 ... ...
测试 ... ... 选择
and 字段 not like '[a-z]%'
and 字段 like '[^a-z]%'
(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]%'