The 2 single quotes with nothing between them is not being interpreted as
your third argument, because 2 single quotes in a row is the way to
represent an "escaped" or literal single quote character.
The problem is really different from the error message: The problem is that
SRPL cannot accept a blank, empty, or null value as the new value (3rd
argument.)
That's an enhancement request I have been making repeatedly since
Wayne Erickson was a boy. Currently, it's in the database with event key #
980, submitted 4/4/2000, with "no status assigned."
In the meantime, you'll have to be creative. Maybe something like:
UPDATE s_users SET phone = +
(SGET( phone, (sloc(phone,'(') -1), 1) + +
sget(phone, (slen(phone) - sloc(phone,'(') + 1), (sloc(phone,'(') + 1 )) +
(SGET( phone, (sloc(phone, '(') - 1), 1) + +
sget(phone, (SLEN(phone) - sloc(phone,'(')), +
(sloc(phone,'(') + 1) )) +
WHERE (sloc(phone, '(')) > 0
Bill
On Wed, 8 Oct 2003 15:32:16 -0500, Fogelson, Steve 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?
