hi, the following soloution may be correct to the extent I understood the issue 🙂

create procedure SpArchai(@apProvedStatus nvarchar(3), @taskid int)

AS

BEGIN

IF lower(@apProvedStatus) NOT IN ('yes','no') RAISERROR ('Please input either...