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!!