Steve, It looks to me like you are changing a single quote to a single quote. What character are you trying to replace?
Jerking the quotes setting around like that is a VERY old technique frought with problems. True this : set var vQ = '''' -- variable will now contain a single quote now assuming you are replacing 'x': Set var vOld = 'x' UPDATE Products SET P_Detail = (SRPL(P_Detail,.vOld,.vQ,1)) WHERE P_Detail CONTAINS .vold With the flag = 1 only text that stands alone separated from the other text by spaces will be replaced. Use zero for the flag is you wish to replace all occurances of the character. Dennis McGrath --- "Fogelson, Steve" <[EMAIL PROTECTED]> 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 >
