Thanks everyone I seem to have a hard time understanding the double quote thing.
Marc -------------------------------------------------- From: "A. Razzak Memon" <[email protected]> Sent: Tuesday, June 28, 2011 2:27 PM To: "RBASE-L Mailing List" <[email protected]> Subject: [RBASE-L] - Re: SRPL ' > At 03:16 PM 6/28/2011, Marc Schluter wrote: > >>I am trying to strip out any apostrophes ' from the last >>name field but can't seem to get this to work. >>UPDATE ptinfo SET L_name = (SRPL(L_name, ''''', '''', 0)) >> >>I think the number of single quotes is messing me up. >> >>Thanks for any suggestions >>Marc >> > > > Marc, > > You will need to double up the quote mark. > > Here's how: > > UPDATE PtInfo SET L_Name = (SRPL(L_Name, '''', '''''', 0)) > RETURN > > That's all there is to it! > > Very Best R:egards, > > Razzak. > >
