I'm using the following sql statement within my program and when it gets to the set option I get incorrect systax error.
qref.sql = "Select * from rates_zones where owner_id = " & ownzip & " zip_postal_code like " & fndnum
I have an option and a text box
If this option then
take data from text box, along with a specific owner
find all the record that are like the text box
I have a case statement to add % signs at the end of the text data