UFN_QTRANSLATE_STATE_GETABBREV

This function returns the abbreviation for a given state.

Return

Return Type
nvarchar(10)

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_QTRANSLATE_STATE_GETABBREV(@ID uniqueidentifier) returns nvarchar(10) 
            AS
            --Used by AdHocQuery and SmartQuery

            BEGIN
                declare @DESCRIPTION nvarchar(10)

                select @DESCRIPTION = ABBREVIATION        
                from dbo.STATE where ID = @ID

                RETURN @DESCRIPTION
            END