用法 patindex('%str1%',str2) 返回str1在str2中的位置
patindex('%123%','12345') 返回1
patindex('%111%','12345') 返回0
patindex('%123%','12345') 返回1
patindex('%111%','12345') 返回0
select
sys_userinfo.fullname,
cast
(sys_userinfo.password
as
varchar
)
as
password,sys_userinfo.alias,sys_userinfo.email,sys_userinfo.phone,sys_userinfo.phone3,sys_userinfo.trueduty,sys_userinfo.dept,sys_role.rolename
as
zyzn
from sys_userinfo left join sys_role on PATINDEX ( ' % ' + sys_role.rolename + ' % ' ,trueduty) > 0
where
sys_role.roletype = ' 2 ' and (sys_userinfo.rolelist like ' %,5,% ' or sys_userinfo.rolelist like ' 5,% ' or sys_userinfo.rolelist like ' %,5 ' )
from sys_userinfo left join sys_role on PATINDEX ( ' % ' + sys_role.rolename + ' % ' ,trueduty) > 0
where
sys_role.roletype = ' 2 ' and (sys_userinfo.rolelist like ' %,5,% ' or sys_userinfo.rolelist like ' 5,% ' or sys_userinfo.rolelist like ' %,5 ' )