sort a text field by the length of it's string

[Garry]

Hi all

ACCESS 2003

Can some one tell me if it's possible to sort a text field by the length of
it's string.

If so HOW ?

Many thanks, Garry

 

[Jeff L]

Yes it is.

SELECT MyField Len([MyField]) AS Expr1
FROM MyTable
ORDER BY Len([MyField]);

 

[Ofer Cohen]

Try

Select * From TableName Order By Len([FieldName])

 

[Garry]

Thanks Both