I have a colu开发者_如何学JAVAmn that contains text in my Access database.
Is there a way to sort this column by the length of the strings in it (without having to write lots of code)? Showing longest strings first, for example.
Thanks.
SELECT StringColumn, len(StringColumn) AS Length
FROM YourTable
ORDER BY len(StringColumn) DESC
精彩评论