/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 vote339 views2 answers
How to update the multiple rows in sql
SQL
7 votes352 views3 answers
Restore postgres database from sql file
SQL
33 votes349 views2 answers
Postgres how to add field created at
SQL
1 vote316 views1 answer
Delete triger pl pg sql
SQL
4 votes396 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote365 views1 answer
Query string starts with vowels
SQL
2 votes383 views3 answers
Mysql pass command from command line
SQL
0 vote335 views1 answer
Sql string length postgresql
SQL
2 votes357 views1 answer
Mysql clear screen
SQL
2 votes351 views1 answer
How to make multiple keys as primary in bdms
SQL