UFN_SALESMETHOD_GETLABEL

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_SALESMETHOD_GETLABEL
(
    @ID uniqueidentifier
)
returns nvarchar(100)
as
begin
    if @ID is null
        return ''
    return coalesce(
    (
        select SALESMETHOD.TYPE
        from dbo.SALESMETHOD
        where SALESMETHOD.ID=@ID
    ),
    '')
end