Using Apostrophe () in data

• Kurt Diseroad

  SSC Rookie

  Points: 48

  More actions

  January 13, 2004 at 9:17 am

  #161085

  I would like to pass in data that contains Apostrophe (') characters to execute a Stored Procedure.  An example that I want to pass the data O'Brien to a stored procedure (ex. execute LOOKUP 'MR_MEMBER' 'O'Brien').  Any ideas how to get around this?

• Jonathan

  SSC-Insane

  Points: 20427

  More actions

  January 13, 2004 at 9:29 am

  #489781

  You can replace the apostrophe with two apostrophes in the front end, but the better solution is to use a parameterized command object. 

  
  
  --Jonathan

• stonemw

  SSC Veteran

  Points: 204

  More actions

  January 14, 2004 at 5:05 am

  #489929

  You could use something like this:

  execute LOOKUP 'MR_MEMBER' 'O' + char(39) + 'Brien'

   

  Just a thought.