This almost worked :p I applied your suggestion in the following way: select * from ihrproperties where region = 'Kerry' and 0 < substring_index(substring_index(rates, ',', 41), ',', -1) < 1568 But of course my prices are saved as text.... so is there a way to type cast the result of the substring_index() or something similar....? -- Regards, Owen Franssen Twisted Design mailto:twisteddesign@eircom.net -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
