select * from Diagnosis where PATINDEX('[A-Z]%', insureICDname)>0 and state=1 and DiagnosisID<='086591000A0000002418'
sqlserver 使用正则实现查找字段以字母开头
更多精彩文章请关注我们的微信公众号FocusDotCore:
select * from Diagnosis where PATINDEX('[A-Z]%', insureICDname)>0 and state=1 and DiagnosisID<='086591000A0000002418'
更多精彩文章请关注我们的微信公众号FocusDotCore: