How to work with quoats or an apostrophe in SQL qu
My database field has single quotes in it. How to deal with it in SQL query? One way I can think of using escape character in the field value. Like---John's books ---Will it work? Is there a better way?<BR>Thanks!