Here is my query where clause:
query1.where = "(name) ='" + dom.byId("SUB").value + "'";
When I run a query, 90% query will return results except if the data has " ' ". For example, if my data has a name called "BRIAN'S ESTATES" then query won't return any results even though you enter the exact same name. Got ideas to change the where clause?