ok, Discard prior discussions and questions to this point as I can use MySQL function "replace()" to strip commas in the values available to the Search Comparison.
For example:
SELECT tblhouseinfo.BedRooms, tblhouseinfo.BathRooms, replace( tblhouseinfo.list_price , ',' , '') AS list_price, tblinventory.* FROM tblhouseinfo JOIN tblinventory ON tblinventory.invId = tblhouseinfo.addInfoID
returns the results shown in the attached screen shot.
But when the Search comparison is run, no results are returned:
SELECT tblhouseinfo.BedRooms, tblhouseinfo.BathRooms, replace( tblhouseinfo.list_price , ',' , '') AS list_price, tblinventory.* FROM tblhouseinfo JOIN tblinventory ON tblinventory.invId = tblhouseinfo.addInfoID WHERE tblinventory.mid = 10 AND (list_price >= 24000) AND (list_price <= 45000)
What as I missing? Greater or Equal to 24000 and Less than or Equal to 45000 should return records: 44900 and also 42500.00 Right??
