SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ALTER PROC dbo.P_IsFilter
@sMessage VARCHAR(8000)
AS
DECLARE
@iResult INT
set nocount on
set @iResult=0
if (EXISTS(select * from T_Filter where charindex(Keyword,@sMessage) > 0))
begin
set @iResult=1
goto exit_proc
end
exit_proc:
set nocount off
return @iResult
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO