set @var1=@var1+'%'select sum(countCT) from TmpX where TmpX.T_Plan_ExcutePlan_PDepartLevel like @var1) 就可以了
不用加啊,直接用就行了吧: set @var1=@var1+'%'select sum(countCT) from TmpX where TmpX.T_Plan_ExcutePlan_PDepartLevel like @var1)--如果@varl内容中还要加',可以用: select sum(countCT) from TmpX where TmpX.T_Plan_ExcutePlan_PDepartLevel like ''''+@var1+'''')
??
就可以了
set @var1=@var1+'%'select sum(countCT) from TmpX where TmpX.T_Plan_ExcutePlan_PDepartLevel like @var1)--如果@varl内容中还要加',可以用:
select sum(countCT) from TmpX where TmpX.T_Plan_ExcutePlan_PDepartLevel like ''''+@var1+'''')