Function - udf_NameParser

Property	Value
Name	udf_NameParser
Schema	dbo
Function Type	Scalar
Deterministic	False
Is Encrypted	False
Ansi Nulls Status	True
Quoted Identifier Status	True
Description

Name	Data Type	Direction	Description
@FullName	varchar(50)	Input
@ReturnInd	varchar(1)	Input

Name	Type
usp_DimCurriculum_Select	StoredProcedure

Name

Type

Object

Property

Value

/****** Object: UserDefinedFunction [dbo].[udf_NameParser] Script Date: 03/09/2017 16:47:10 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE FUNCTION [dbo].[udf_NameParser]
    (
    @FullName VARCHAR(50)
    ,@ReturnInd varchar(1)
    )
RETURNS varchar(50)
AS
BEGIN
    DECLARE @CommaLoc int
    DECLARE @ReturnName varchar(50)
IF @ReturnInd = '1'
BEGIN
        SET @CommaLoc = PATINDEX('%,%', @FullName)
        SET @ReturnName =
          CASE
            WHEN @CommaLoc >= 1      THEN LEFT(@FullName, @CommaLoc - 1)
            WHEN @CommaLoc < 1       THEN @FullName
          END
END
IF @ReturnInd = '2'
BEGIN
        SET @FullName = RTRIM(@FullName)
        SET @CommaLoc = PATINDEX('%,%', @FullName)
        SET @FullName =
          CASE
              WHEN @CommaLoc >= 1      THEN LTRIM(RIGHT(@FullName, LEN(@FullName) - @CommaLoc))
              WHEN @CommaLoc < 1       THEN NULL
          END
        SET @CommaLoc = PATINDEX('%,%', @FullName)
        SET @ReturnName =
           CASE
               WHEN @CommaLoc >= 1      THEN LEFT(@FullName, @CommaLoc - 1)
               WHEN @CommaLoc < 1       THEN @FullName
           END
END
IF @ReturnInd = '3'
BEGIN
        SET @FullName = RTRIM(@FullName)
        SET @CommaLoc = PATINDEX('%,%', @FullName)
        SET @FullName = LTRIM(RIGHT(@FullName, LEN(@FullName) - @CommaLoc))
        SET @CommaLoc = PATINDEX('%,%', @FullName)
        SET @FullName =
           CASE
               WHEN @CommaLoc >= 1      THEN LTRIM(RIGHT(@FullName, LEN(@FullName) - @CommaLoc))
               WHEN @CommaLoc < 1       THEN NULL
           END
        SET @ReturnName = @FullName
END
    RETURN @ReturnName
END