<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a competition message. I want to create a new table using query analyser using an SQL statement.<br />
<br />
It shoud sort the competition message from shortest length to greatest length.<br />
<br />
I am using to do this in SQL and only ASP as a last resort.<br />
<br />
Thanks, tp
</div>
</div>


Hi,

I have a competition message. I want to create a new table using query analyser using an SQL statement.

It shoud sort the competition message from shortest length to greatest length.

I am using to do this in SQL and only ASP as a last resort.

Thanks, tp

SQL: order by amount of characters within a field

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.