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

