fnEmailListName

        CREATE  FUNCTION [dbo].[fnEmailListName]
            (    
            @PKID int
            )
            RETURNS nvarchar(50)
            AS
            BEGIN
                DECLARE @deleted bit
                DECLARE @listName nvarchar(50)
                select @listName=[Name], @deleted=[deleted] from dbo.emaillist where [ID]=@PKID 
                if (@deleted=1)
                    set @listName='List has been deleted'
                return @listName
        END