Thanks for all the responses. Got it to work with. I am curious. I am grateful for the help I get from this list and I was wondering if it is poor list etiquette to respond with a thanks on the list. If only one person responds, I usually respond off list.
Thanks Steve -----Original Message----- From: Mike Willochell [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:59 AM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: [No Subject] At 10:15 AM 10/17/2003 -0500, Steve Fogelson wrote: >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
