UPDATE s_users SET phone =
SGET(phone( (SLOC(Phone,'(')), 1) + +
SGET(phone( (SLEN(PHone)-(SLOC(Phone,'(')),(SLOC(Phone,'(') + 1)
You will have to sort out the ((())), but this is the idea. You first SGET all the
characters before the (, then all the characters after the (.
Repeat for )
"Fogelson, Steve" <[EMAIL PROTECTED]> wrote:
>I want to delete ( from phone numbers.
>
>I used the following:
>
>UPDATE s_users SET phone = (SRPL(phone,'(','',0)) WHERE phone CONTAINS '('
>
>But get an error that states "Argument 3 of SRPL cannot be 0". It must not
>like not having a character in argument 3.
>
>Any ideas?
>
>Thanks
>
>Steve
>Internet Commerce Solutions
>
>
--
Albert Berry
Full Time Consultant to
PSD Solutions
350 West Hubbard, Suite 210
Chicago, IL 60610
312-828-9253 Ext. 32
__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397
Get AOL Instant Messenger 5.1 free of charge. Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
