SELECT LEAST()

[nikko50]

I'm trying to select the LEAST value > than 0 in a field "NDA". I tried the below but get MYSQL syntax error. How can this be done.

SELECT LEAST(NDA)
FROM QUOTES WHERE SHIPPER = "1225"
AND NDA > '0'

[cahva]

Just by ordering and limit you can achieve what you are looking for:

SELECT NDA FROM QUOTES 
WHERE SHIPPER = "1225" AND NDA > 0 
ORDER BY NDA ASC LIMIT 1;

That will return the lowest NDA. BTW, do you really have all your fields and tables UPPERCASE?