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
