based on the code in comments
declare @error int
declare @error_message nvarchar (200)
declare @ItemCode nvarchar (200)
if not exists( SELECT * FROM IGN1 WHERE [ItemCode] Like 'AP%' OR [ItemCode] Like 'ZP%' )
BEGIN
SET @error=-1
SET @error_message= 'This Field is Mandatory'
select @error_message
END
EXISTS (Transact-SQL)[
^]