UFN_TRANSLATIONFUNCTION_SEARCHLIST_GETNAME

            create function dbo.UFN_TRANSLATIONFUNCTION_SEARCHLIST_GETNAME(@ID uniqueidentifier) returns nvarchar(60) 
            with execute as caller
            AS
            BEGIN
                declare @NAME nvarchar(60)
                select @NAME = NAME from dbo.SEARCHLISTCATALOG where ID = @ID
                return @NAME
            END