用String Function PATINDEX,语法如下:
PATINDEX('%pattern%', expression)例:
select SDID,SDFieldName from SDTableName where PATINDEX('%子字符串%', SDFieldName)>0结果:返回所有SDFieldName中含“子字符串”的记录
PATINDEX('%pattern%', expression)例:
select SDID,SDFieldName from SDTableName where PATINDEX('%子字符串%', SDFieldName)>0结果:返回所有SDFieldName中含“子字符串”的记录
如果返回是0就是没有!否则就有