Hi guys

I hope this is someting you can help me with

Basically, I'm looking to query my sql server database using the following query

-----------
SELECT MIN(mileage) AS minmileage, MAX(mileage) AS maxmileage
FROM mytable
where make = 'audi'
and mileage > 10000"
-----------

So I simply want to display the lowest mileage that's higher than 1000 in my database. However, the problem I have is that the "mileage" column in my table has a nvarchar format (don't ask) and I'm not able to change the format of the field.

However, I understand I can do this via the query (CAST or Convert???).

I have looked at so many articles but I just can't get anything to work. I get results but not as I would expect. For example, I'm getting strange results where the minmileage value for an Audi is 100000 when I know there are Audis with mileages around 25000.

Any help would be fully appreciated

Best regards

Rod from the UK