order query results by field length?

Anyone know of an easy way to order results of a query by the length of
one of the fields?
ie. the record with the longest text in the 'description' field is
returned first?

Cheers,
Ciarán

cronoklee@hotmail.com wrote:
> Anyone know of an easy way to order results of a query by the length of
> one of the fields?
> ie. the record with the longest text in the 'description' field is
> returned first?

Yes, you can put expressions into the ORDER BY clause:

SELECT ...
FROM ...
ORDER BY LENGTH(description) DESC

Regards,
Bill K.

Brilliant! worked a charm Thanks Bill!