Hi guys I am working on a site that will use information stored in a database. I have a field in the database called minRate which stores a price - such as 98, 737 222 etc. The database information comes from a datafeed. The problem I am facing is that for the values in the minRate field that are 100 and more - there is a whitespace before the numbers start. My problem is that I want to select records from the database and list them in price order with the lowest price appearing first, but because of this whitespace, records with the price 100 are appearing above records with the price of 28, 33, etc. I have implemented the TRIM command into my query, and this does work to an effect in removing the whitespace when I display the price. However, I cannot seem to get this working with regards to the order command. Below is my query... $results = mysql_query("SELECT hotelname,rating,address,imageId,hotelFileName,sellers,TRIM(minRate) AS minRate2,SUBSTRING(imageId,1,3) AS imageId_3 FROM hotels WHERE cityName='Citynamehere' AND minRate!='' ORDER BY minRate2 ASC LIMIT $page, $limit"); In the above code, I am trimming the minrate data and naming is as minRate2. The part that says minRate!='' is so that if the price field in the database is empty, it won't require those records. The problem I have having is with the ORDER BY minRate2. I have tried various ways of ordering the records by the trimmed minrate without the whitespace, but I am getting nowhere. Can anyone help and let me know where I am going wrong ?? Thanks for reading. Alex