# Function: ufnGetPurchaseOrderStatusText

## Properties

Property | Value
--- | ---
Name | ufnGetPurchaseOrderStatusText
ID | 87671360
Schema | dbo
Owner | dbo
Execute As | Caller
Type | SQL SCALAR FUNCTION
Uses Ansi Nulls |
Uses Quoted Identifier |
Is Schema Bound |
Uses Database Collation |
Null on Null Input |
Encrypted |
MS Shipped |
Published |
Schema Published |
Deterministic |
Precise |
System Verified |
System Data Access |
User Data Access |
Modify Date | 8/8/2010 5:23:46 PM
Creation Date | 8/8/2010 5:23:46 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table.

## Permissions

No object level permissions defined.

## Parameters

Parameter Name | Datatype | Has Default Value | Default Value | Read Only | Xml Document | Description
--- | --- | --- | --- | --- | --- | ---
@Status | tinyint |  |  |  |  | Input parameter for the scalar function ufnGetPurchaseOrdertStatusText. Enter a valid integer.

## Recordset Returned

Datatype | Has Default Value | Default Value | Xml Document | Description
--- | --- | --- | --- | ---
nvarchar(15) |  |  |  |

## Objects that depend on [ufnGetPurchaseOrderStatusText]

- dbo.ufnGetPurchaseOrderStatusText

## Objects on which [ufnGetPurchaseOrderStatusText] depends

- dbo.ufnGetPurchaseOrderStatusText

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE FUNCTION [dbo].[ufnGetPurchaseOrderStatusText](@Status [tinyint]) RETURNS [nvarchar](15) AS BEGIN DECLARE @ret [nvarchar](15); SET @ret = CASE @Status WHEN 1 THEN 'Pending' WHEN 2 THEN 'Approved' WHEN 3 THEN 'Rejected' WHEN 4 THEN 'Complete' ELSE '** Invalid **' END; RETURN @ret END; EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Input parameter for the scalar function ufnGetPurchaseOrdertStatusText. Enter a valid integer.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'ufnGetPurchaseOrderStatusText', @level2type=N'PARAMETER',@level2name=N'@Status' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'FUNCTION',@level1name=N'ufnGetPurchaseOrderStatusText'

#### See also

List of Functions