length function
From: Joet Singh <jsingh_at_bigfoot.com>
Date: Mon, 8 Nov 1999 21:19:21 -0600
Message-ID: <tpMV3.14300$Ph7.98922_at_insync>
Hi All,
[Quoted] [Quoted] I am trying to do a check to make sure that when a person fills out a phone [Quoted] number field that the it contains correct number of digits. I have a check [Quoted] to do this but it keeps running into a problem. The check is in the form of a if statement:
[Quoted] If length(home_area)=3 and length(home_three)=3 and length(home_four)=4 then *do Something*
else *Do something*
[Quoted] Now if the value being inserted in the home_area field is 123 this is ok then length of this string is 3 but is the value is 012 the length of this string is 2. Now how do I tell the program that the string is really 3 digits long and the "0" value is not a null value? Any ideas? Thanks in advance Received on Tue Nov 09 1999 - 04:19:21 CET
Date: Mon, 8 Nov 1999 21:19:21 -0600
Message-ID: <tpMV3.14300$Ph7.98922_at_insync>
Hi All,
[Quoted] [Quoted] I am trying to do a check to make sure that when a person fills out a phone [Quoted] number field that the it contains correct number of digits. I have a check [Quoted] to do this but it keeps running into a problem. The check is in the form of a if statement:
[Quoted] If length(home_area)=3 and length(home_three)=3 and length(home_four)=4 then *do Something*
else *Do something*
[Quoted] Now if the value being inserted in the home_area field is 123 this is ok then length of this string is 3 but is the value is 012 the length of this string is 2. Now how do I tell the program that the string is really 3 digits long and the "0" value is not a null value? Any ideas? Thanks in advance Received on Tue Nov 09 1999 - 04:19:21 CET