SELECT * FROM TB WHERE COL LIKE '%[a-zA-Z]%' AND COL IS NOT NULL??
SELECT * FROM TB WHERE PAITINDEX('%[A-z]%',COL)<0 AND COL IS NOT NULL
SELECT * FROM TB WHERE PATINDEX('%[A-z]%',COL)<0 AND COL IS NOT NULL
SELECT * FROM TB WHERE PATINDEX('%[A-z]%',COL)<0 AND col<>char(33)
CREATE TABLE TBTEST( VARSTRING VARCHAR(10)) INSERT TBTEST SELECT N'中国' UNION ALL SELECT ' 'UNION ALL SELECT 'A' SELECT * FROM TBTEST WHERE VARSTRING NOT LIKE '%[A-Z]%' AND VARSTRING IS NOT NULL AND VARSTRING<>' ' VARSTRING ---------- 中国(所影响的行数为 1 行)
那你的又有中文,又有英文的的字段 有规律不 比如说 开头都是中文字 末尾都是中文字 举个例子,如果开头都是中文字 select * from tb where PATINDEX('%[A-z]%',left(COL,1))<0 AND left(COL,1))<>char(33)
create table fancycgx3650(name varchar(20)) delete from fancycgx3650 insert into fancycgx3650 select '中国' union all select '中文' union all select 'AAA' union all select 'B B' union all select 'AA中' union all select 'BB ' SELECT * FROM fancycgx3650 WHERE name not LIKE '%[a-zA-Z]%' AND name IS NOT NULL
INSERT TBTEST
SELECT N'中国' UNION ALL
SELECT ' 'UNION ALL
SELECT 'A' SELECT * FROM TBTEST WHERE VARSTRING NOT LIKE '%[A-Z]%' AND VARSTRING IS NOT NULL AND VARSTRING<>' '
VARSTRING
----------
中国(所影响的行数为 1 行)
举个例子,如果开头都是中文字
select * from tb where PATINDEX('%[A-z]%',left(COL,1))<0 AND left(COL,1))<>char(33)
create table fancycgx3650(name varchar(20))
delete from fancycgx3650
insert into fancycgx3650
select '中国' union all
select '中文' union all
select 'AAA' union all
select 'B B' union all
select 'AA中' union all
select 'BB ' SELECT * FROM fancycgx3650 WHERE name not LIKE '%[a-zA-Z]%' AND name IS NOT NULL