VBstring "People's Verdict" rejected with Syntex err message
I am sending an string like "People's Verdict" from a VB application to MSSQLServer for an update using DAO. It gives syntex error because of apostrophe i.e. '. (If the input is like "Peoples Verdict" there is no error.)
Can any body suggest how to handle this.