-- First I would check for commas, if any. One is enough, and the count
will stop at the first instance of the comma. Create the whole command
in a variable, then just run the one variable. I set the table and
column to 'ColumnName' and 'TableName' so I could easier see the results
in the command line.
SET VAR vCommand TEXT = ('UPDATE' & .fxtxhqtable & +
'SET' & .fxtxhqcolumn & '= (SRPL(' + .fxtxhqcolumn + +
',CHAR(44),NULL,0))' & 'WHERE' & .fxtxhqcolumn & 'CONTAINS CHAR(44)')
SHOW VAR vCommand
UPDATE TableName SET
ColumnName =
(SRPL(ColumnName,CHAR(44),NULL
,0)) WHERE ColumnName
CONTAINS CHAR(44)
You can run the command with
&vCommand in the stored procedure.
I hope this helps a bit.
Albert
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
