order by field value length

[Costas]

--SQL or SQLITE
SELECT ADDRESS FROM CUSTOMERS ORDER BY LEN(ADDRESS) DESC

--MYSQL
SELECT ADDRESS FROM CUSTOMERS ORDER BY CHAR_LENGTH(ADDRESS) DESC