select *,'Eng' from tb where patindex('%[a-z]%',col)>0 and (patindex('%[吖-坐]%',col)=0)
union all
select *,'CN' from tb where patindex('%[吖-坐]%',col)>0 and patindex('%[a-z]%',col)=0
union all
select *,'Eng&CN' from tb where (patindex('%[吖-坐]%',col)>0) and patindex('%[a-z]%',col)>0