Vic, you missed it - Of course I never mist maketakes. He is replacing a set of characters within a longer string.
Steve, I think you need to use the 0 option rather than the 1 in the fourth paramter. 1 requires the string to be surrounded by spaces (separate word), while 0 allows replacement of the exact character set even when it appears to be part of a word. "Victor Timmons" <[EMAIL PROTECTED]> wrote: >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 > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
