Victor, I might be wrong, but wouldn't that set the column P_Detail = |'| When I just want the occurences of ' changed to '
Steve -----Original Message----- From: Victor Timmons [mailto:[EMAIL PROTECTED] Sent: Friday, October 17, 2003 10:50 AM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: [No Subject] Maybe I don't get to but could you just do this UPDATE Products SET P_Detail = |'| WHERE P_Detail CONT |'| Im not sure why you would use SRPL On 17 Oct 2003 at 10:15, Fogelson, Steve 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. > > Thanks > > Steve Fogelson > Internet Commerce Solutions > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
