开发者

Microsoft Access: How to sort text column by length of its text string?

开发者 https://www.devze.com 2023-03-29 18:44 出处:网络
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 longe

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
0

精彩评论

暂无评论...
验证码 换一张
取 消