I notice an =40 in your select statement that is not allowed in UPDATE.
The =40 is a display width used when SELECTing to the screen only. I
have deleted your prior posts, so I don't remember seeing it in the
UPDATE, but if it is there, take it out and try again.
Albert
On 3/28/2014 10:56 AM, James Bentley wrote:
Mike
Thanks. I had considered that alternative but I believe there
may be a glitch in the syntax editor as I should not have to
code two lines since the following works in a select statement:
SELECT (SRPL(&FxTXHqColumn,CHAR(44),NULL,0))=40 FROM &FxTXHqTable
WHERE &FxTXHqColumn CONTAINS CHAR(44)
Here is the results of executing that statement:
(SRPL(TXHqLastName,CHAR(44),NULL,0))
----------------------------------------
Gutierrez
Note! The SRPL statement is exactly the same as in my UPDATE
statement. Why does it work in one case and not the other?
I have decided to open a problem with RDCC.
