UFN_NAMEFORMATFIELD_GETDESCRIPTION

                create function dbo.UFN_NAMEFORMATFIELD_GETDESCRIPTION(@ID uniqueidentifier)
                returns nvarchar(50)
                as begin
                    if @ID is null
                        return '';

                    return coalesce((select DISPLAY from dbo.NAMEFORMATFIELD where ID=@ID), '');
                end