[RBASE-L] - Re: SRPL '

[MDRD]

It is a column

Marc



From: Bernard Lis 
Sent: Tuesday, June 28, 2011 2:30 PM
To: RBASE-L Mailing List 
Subject: [RBASE-L] - Re: SRPL '


Is L_name a variable?  Shouldn't it have a dot in front of it?
  ----- Original Message ----- 
  From: MDRD 
  To: RBASE-L Mailing List 
  Sent: Tuesday, June 28, 2011 3:16 PM
  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