I am working with a database and a field in it is called Weight. I am not sure why, but the made it a varchar type and all data in the field has a label on it. So the data in the field in the db looks like this:<BR><BR>130 lbs.<BR>155 lbs.<BR>75 lbs.<BR><BR>So this is kind of a mess already. My problem is I am trying to write an interface where a user can enter in criteria and do a search on this table. So I want to have it where there are 2 fields for weight and after user fills in both, it looks for records with weight in between those numbers. Is there a way I can conver that data in my sql statement and use it for numerical comparison?