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

Reply via email to