/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

0 vote122 views1 answer
Sql check for null and empty string
SQL
0 vote121 views1 answer
How to print out column name differently in mysql
SQL
0 vote154 views2 answers
Nested query
SQL
17 votes132 views3 answers
Cast in sql server
SQL
4 votes133 views1 answer
Wildcard in sql
SQL
0 vote189 views1 answer
Replace null value within column mysql
SQL
0 vote128 views1 answer
Insert set mysql
SQL
0 vote129 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote130 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote122 views1 answer
Sql server whoami
SQL