Searching Names with '

• gandrade

  SSC Enthusiast

  Points: 100

  More actions

  June 5, 2003 at 1:13 pm

  #159985

  I have an ASP page that generates my SQL statement when doing a search on last name. My problem is when searching for names like "O'leary" it fails beacause of the '. Do I have to use a LIKE statement or is there another way to do this?

• Oleg D

  SSC Veteran

  Points: 279

  More actions

  June 5, 2003 at 1:31 pm

  #460034

  I might simply double it like

  O''leary

• gandrade

  SSC Enthusiast

  Points: 100

  More actions

  June 5, 2003 at 2:02 pm

  #460041

  Thanks Oleg that did it!