为什么有用"LIKE"的存储过程不起作用

[SLBS]

我的一存储过程为
CREATE PROCEDURE CheckIsIn_PRIJIANBOM_color @Check_falg Char(1) output , @FieldData1 char(20), @FieldData2 char(20), @FieldData3 char(20) AS BEGIN if Exists( Select * from PJBBOM Where cxpz= @FieldData1 And lmth like @FieldData2 And sl=@FieldData3 ) Set @Check_falg='Y' Else Set @Check_falg='N' END

GO

有用"LIKE"的存储过程不起作用

[pbsql]

lmth like '%'+rtrim(@FieldData2)+'%'

[zlp321002]

CREATE PROCEDURE CheckIsIn_PRIJIANBOM_color @Check_falg Char(1) output , @FieldData1 char(20), @FieldData2 char(20), @FieldData3 char(20) AS BEGIN if Exists( Select * from PJBBOM Where cxpz= @FieldData1 And lmth like '%+@FieldData2+%' And sl=@FieldData3 ) Set @Check_falg='Y' Else Set @Check_falg='N' END

GO

[软件钢琴师]

BEGIN
if Exists( Select * from PJBBOM
Where cxpz= @FieldData1 And lmth like ''%'+@FieldData2+'%'' And sl=@FieldData3 ) Set @Check_falg='Y'
Else
Set @Check_falg='N'
END