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.
