UFN_GETNAME_BY_SOLICITCODE

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



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

        select @NAME = isnull(DESCRIPTION, '')
        from dbo.SOLICITCODE
        where ID = @ID;

        return @NAME;
      end