MSSQL写了一个
select *
from 表
where
ASCII(SUBSTRING(字段1,1,1)) >=97 and ASCII(SUBSTRING(字段1,1,1))<=122
select *
from 表
where
ASCII(SUBSTRING(字段1,1,1)) >=97 and ASCII(SUBSTRING(字段1,1,1))<=122
http://www.gaodaima.com/?p=37415查询sql数据库某个字段里所有以小写字母_sqlserver
欢迎大家阅读《查询sql数据库某个字段里所有以小写字母_sqlserver》,跪求各位点评,若觉得好的话请收藏本文,by 搞代码