Maybe it is an idea to use (CHAR(39)) instead of '
Tony From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: dinsdag 28 juni 2011 21:16 To: RBASE-L Mailing List Subject: [RBASE-L] - SRPL ' HI 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
