UFN_STATE_GETABBREVIATION

Return

Return Type
nvarchar(50)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_STATE_GETABBREVIATION(@ID uniqueidentifier) 
returns nvarchar(50
with execute as caller
as
begin
    declare @ABBREVIATION nvarchar(50)

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

    return @ABBREVIATION
end