SELCT FROM Problem

• Juan Ricardo Tomasino

  SSC-Addicted

  Points: 444

  More actions

  May 16, 2006 at 3:03 pm

  #103163

  Hello SQLers.

  This sounds like a really dumb question but I'm really stumped on this one.

  I have a database table with a column NAME (which is a string) and there are entries in this column with apostrophes. When I try to execute a simple query like

  select * from ThisTable where Name = 'Mike's Ball'

  I have an error because of the apostraphe in Mike. If I am allowed to write this character, I'm assuming there is a way to query it .... I JUST CAN'T FIGURE OUT WHAT IT IS! HELP! I'M GOING CRAZY MAN!!

• David Scotland-132255

  SSCertifiable

  Points: 5599

  More actions

  May 16, 2006 at 3:06 pm

  #638283

  select * from ThisTable where Name = 'Mike''s Ball'

   

  hth

  David

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  May 16, 2006 at 3:09 pm

  #638284

  You should also take a look at QUOTENAME:

  http://msdn2.microsoft.com/en-us/library/ms176114(SQL.90).aspx