[RBASE-L] - [No Subject]

[Fogelson, Steve]

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.

Thanks

Steve Fogelson
Internet Commerce Solutions