UFN_DISBURSEMENTPROCESS_RANGESGRID_DONOTALLOWCHECKNUMBERGREATERTHANNINE

Do not allow a check number with more than 9 digits

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@RANGESGRID	xml	IN

Definition

Copy



create function dbo.UFN_DISBURSEMENTPROCESS_RANGESGRID_DONOTALLOWCHECKNUMBERGREATERTHANNINE(@RANGESGRID xml)
returns bit
with execute as caller
as begin
    declare @ReturnValue bit;
    set @ReturnValue=0;
    declare @TempTable table
    (
        [START] int
    ,[END] int
    );

    insert into @TempTable
        select 
            [RANGESTART]
      ,[RANGEEND]
        from dbo.UFN_DISBURSEMENTPROCESSFORMNUMBERRANGE_FROMITEMLISTXML(@RANGESGRID);

    if exists
    (
        select * from @TempTable where len([START])>9 or len([END])>9
    )    
    set @ReturnValue = 1;

    return @ReturnValue;
end