UFN_TRANSLATIONFUNCTION_MERCHANDISEDEPARTMENT

            create function dbo.UFN_TRANSLATIONFUNCTION_MERCHANDISEDEPARTMENT(@ID uniqueidentifier) returns nvarchar(50) 
            as
            begin
                declare @NAME nvarchar(50);
                select @NAME = NAME from dbo.MERCHANDISEDEPARTMENT where ID = @ID;
                return @NAME;
            end