UFN_NAMINGOPPORTUNITY_BUILDNAME

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

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