UFN_ADDRESSPROCESSINGOPTION_GETNAME

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_ADDRESSPROCESSINGOPTION_GETNAME]
(
  @ID uniqueidentifier
)
returns nvarchar(100)
as
  begin
    declare @NAME nvarchar(100);

    select 
      @NAME = isnull([NAME], '')
    from
      dbo.[ADDRESSPROCESSINGOPTION]
    where
      [ID] = @ID;

    return @NAME;
  end;