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

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

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