instead of looking specifically for those 3 characters, you could just say
you want a numeric value (you likely don't want any %!#%! or alphas).

so:

phone = rereplace(phone, '[^0-9]', '', 'all');

should work.

----- Original Message -----
From: "Janine Jakim" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 06, 2004 7:37 AM
Subject: Strip ()-

> On a phone number field I want to make sure that users haven't added ()-.
> I figure the easiest way is to strip it off before entering it into the
> database.
> How would I set that?
> Thanks,
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to