UFN_SEARCHLIST_EXISTS

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SEARCHLIST_EXISTS (@ID as uniqueidentifier)
            returns bit
            with execute as caller
            as
            begin
                if exists(select ID from dbo.SEARCHLISTCATALOG where ID = @ID)
                    return 1;

                return 0;
            end