I have the following query to pull data in FP2000: s-sql="SELECT * FROM Company WHERE ('::CompanyName::' in (",CompanyName)) AND ('::City::' in (",City)) AND ('::County::' in (",County)) AND ('::StateorProvince::' in (",StateorProvince)) AND ('::Postalcode::' in (",Postalcode)) ORDER BY CompanyName ASC
When I save it drops the second part of the first fields values: WHERE ('::CompanyName::' in (''AND ... the rest of the code is fine.
I have five text boxes and the user does not have to fill all of them in to run the query. It should run using as many of the fields as they populate.
Will this code work with some kind of modification for the "in" statement? If not, how do I go about this query?