/SQL/Order by number of character in sql

Order by number of character in sql

You can also sort or order by the Number of Characters in each Column you wish 
to sort by. Shown below is a sample which sorts by the first three characters 
of the First Name and by the last two characters in the name of the town.

    SELECT *
    FROM table_name
    ORDER BY LEFT(FirstName, 3) ASC, LEFT(Town, 2);

Similar codes

8 votes225 views4 answers
Convert date to dd/mm/yyyy sql
SQL
0 vote182 views1 answer
T-sql update table variale
SQL
3 votes179 views2 answers
Postgresql remove not null constraint
SQL
3 votes253 views2 answers
How to modify rows in SQL Server
SQL
8 votes198 views10 answers
Sql
SQL
1 vote217 views1 answer
Postgres count string length
SQL
0 vote203 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
2 votes202 views1 answer
Oracle sql merge
SQL
0 vote183 views1 answer
Sql server datetime to string
SQL
-1 vote195 views3 answers
How to restart mysql in linux
SQL