UFN_ITINERARYITEM_GETNAME

Returns the name of an itinerary item based on a system record ID.

Return

Return Type
nvarchar(100)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_ITINERARYITEM_GETNAME(@ID uniqueidentifier)
            returns nvarchar(100)
            as begin
                return isnull((select NAME from dbo.ITINERARYITEM where ID = @ID), '');
            end