AdventureWorks

Basic Index   Expanded Index

Function:dbo.ufnGetDocumentStatusText
Output Type:nvarchar (16)

Input ParameterType
@Statustinyint


CREATE FUNCTION [dbo].[ufnGetDocumentStatusText](@Status [tinyint])
RETURNS [nvarchar](16)
AS
BEGIN
DECLARE @ret [nvarchar](16);
SET @ret =
CASE @Status
WHEN 1 THEN N'Pending approval'
WHEN 2 THEN N'Approved'
WHEN 3 THEN N'Obsolete'
ELSE N'** Invalid **'
END;

RETURN @ret
END;