I am trying to change ' to a single quote in a column. I used the following commands:
SET QUOTES=NULL
SET QUOTES=|
UPDATE Products SET P_Detail = (SRPL(P_Detail,|'|,|'|,1)) WHERE P_Detail CONTAINS |'|
SET QUOTES=NULL
SET QUOTES='
It says it updated 135 rows, but when I check them they are still '
Any ideas about what I am doing wrong.
Steve;
Try either of the following:
----Option 1----
SET QUOTES=|
UPDATE Products SET P_Detail = (SRPL(P_Detail,|'|,|'|,0)) WHERE P_Detail + CONTAINS |'|
SET QUOTES='
----Option 2----
SET QUOTES='
UPDATE Products SET P_Detail = (SRPL(P_Detail,''',(CVAL('QUOTES')),0)) +
WHERE P_Detail CONTAINS '''Best Regards,
Mike
