If you insist on keeaping the character field, try: ( 'Requested storage amount in GB: ' LIKE "*[^.0-9]*" ) OR ( 'Requested storage amount in GB: ' LIKE "*.*.*" )...then throw error
You can play around and make it smarter by allowing leading or trailing spaces, disallowing "." etc. -Rabi Tripathi --- "Barber, Sue" <[EMAIL PROTECTED]> wrote: > Hi all, > > > > I have a question for you on validating field data. > I did search the > archives and it isn't allowing me to open the notes > - says file not > found, sooo... > > > > I have a form that people can use to request > additional network space > with and the field in question is for them to enter > the amount of space > in GB that they want. I originally had the field > limited with $DIGIT$, > but when they made a mistake the entire form was > being reset. They > decided they would like a message to be used > instead, so I have created > a filter that verifies the field as such: > > > > ( 'Requested storage amount in GB: ' != $NULL$ ) > AND ( NOT ( > 'Requested storage amount in GB: ' LIKE > "[.0-9][.0-9][.0-9] > [.0-9][.0-9]")) > > > > However, I don't want to force them to enter a > number into all 5 > spaces, so I need to allow 4 of these to be NULL. > Anyone know if there > is a way to do that? They want to be able to enter > numbers or > decimals - like 2 or 2.5. > > > > Thanks, Sue > > > > ARS 6.3 - patch 20 > > Solaris > > Help Desk 6 > > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org ARSlist:"Where the Answers Are" > ____________________________________________________________________________________ Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"