sqlserver 使用正则实现查找字段以字母开头

select * from Diagnosis where PATINDEX('[A-Z]%', insureICDname)>0 and state=1 and DiagnosisID<='086591000A0000002418'

posted @ 2021-09-28 15:06  tianfeng.cc  阅读(362)  评论(0)    收藏  举报