UPDATE ptinfo SET L_name = (SRPL(L_name, '''', '', 0))
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Tuesday, June 28, 2011 2:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SRPL ' Try this: Use four quotes for your find string. This will evaluate to a single quote Use 2 quotes for your substitute string. This will evaluate to NULL Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Tuesday, June 28, 2011 2:16 PM 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
