UFN_IRSFORM1099MISCPROCESSTEMPLATE_PHONENUMBERVALID

Validates that there are no more than 15 digits in a phone number

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@PHONENUMBER	nvarchar(25)	IN

Definition

Copy



create function dbo.UFN_IRSFORM1099MISCPROCESSTEMPLATE_PHONENUMBERVALID
(
    @PHONENUMBER nvarchar(25)
)
returns bit
with execute as caller
as begin
    declare @DIGITCOUNT int = 0
    declare @LOOPCOUNT int = 0
    while (@LOOPCOUNT <=len(@PHONENUMBER))
        begin
            set @LOOPCOUNT = @LOOPCOUNT + 1
            if substring(@PHONENUMBER,@LOOPCOUNT,1) in ('0','1','2','3','4','5','6','7','8','9') 
                begin
                    set @DIGITCOUNT = @DIGITCOUNT + 1
                end
        end

    if (@DIGITCOUNT > 15)
        begin
            return 1;
        end
    return 0;
end