SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE FUNCTION RegistrationHandler( @sysid varchar(50), @content_name varchar(50), @mobile_number varchar(20), @regval char(1))RETURNS varchar(160)ASBEGIN DECLARE @rtval varchar(160) IF EXISTS(Select * from IsMobileRegistered(@content_name,@sysid,@mobile_number)) IF @regval = 'Y' --Already registered BEGIN SET @rtval=(Select * from GetErrorMessage('REGALREADY')) END ELSE IF @regval = 'N' -- Not registered BEGIN @rtval='Not Registered' END ELSE --New user IF @regval = 'Y' --register new user BEGIN @rtval='New user registered' END ELSE IF @regval = 'N' BEGIN @rtval='New user not registered so cannot cancel' END -- Return the result of the function RETURN @rtvalENDGO