Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Length funtion syntax

Re: Length funtion syntax

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Tue, 09 Nov 1999 13:51:52 +0100
Message-ID: <382818E8.B9E86224@unilog.fr>

Joet Singh a écrit :

> Hi All,
> I am trying to do a check to make sure that when a person fills out a phone
> number field that the it contains correct number of digits. I have a check
> to do this but it keeps running into a problem. The check is in the form of
> a if statement:
> If length(home_area)=3 and length(home_three)=3 and length(home_four)=4 then
> *do Something*
> else *Do something*
> 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

May be you datas home_area, home_three and/or home_four are NUMBER ... Received on Tue Nov 09 1999 - 06:51:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US