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
