How to read Punctuation Symbol value from database?

Question

Dear Honors

I'm using Sql server database..

I stored the varchar field with Some Punctuation Symbol like

 SPENCER'S PLAZA...
It stores fine.. But when I read from the database it shows the error because of the punctuation symbol error..

How to read the value with punctuation symbol from sql database?..

Kindly check the following query
customername=spencer's plaza
select customername from tablename where customername='spencer's plaza'

Thanks in Advance,

Regards,