/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 vote199 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote204 views1 answer
Postgresql in vs any performance
SQL
2 votes293 views1 answer
Oracle list grants on package
SQL
0 vote152 views1 answer
Update set with join pl sql
SQL
2 votes187 views1 answer
Alter table add multiple columns postgresql
SQL
7 votes219 views1 answer
Mysql unsafe update
SQL
0 vote222 views1 answer
Oracle to_number
SQL
0 vote191 views1 answer
How to reset the database value in SQL server
SQL
1 vote189 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote190 views1 answer
Mysql sql.gz
SQL