UFN_PDCATEGORYDEFINITION_VALIDCODELENGTHS

Validates the number of characters in FROMCODE and TOCODE fields

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@FromCode	varchar(30)	IN
@ToCode	varchar(30)	IN

Definition

Copy



create function [dbo].[UFN_PDCATEGORYDEFINITION_VALIDCODELENGTHS](@FromCode varchar(30), @ToCode varchar(30))
returns bit
with execute as caller
as begin
    declare @retval bit = 1
    declare @SegLength int

    select @SegLength = LENGTH from dbo.PDACCOUNTSTRUCTURE WHERE SEGMENTTYPE = 1
    if len(@FromCode) > 0 or len(@ToCode) > 0
        begin
        if len(@FromCode) != @SegLength or len(@ToCode) != @SegLength
            set @retval = 0        
        end

    return @retval
end