/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 vote283 views1 answer
Sql beginning of previous month
SQL
4 votes326 views1 answer
Ms sql truncate table vs delete
SQL
0 vote309 views1 answer
Compare field sql server
SQL
8 votes287 views1 answer
Alter tablespace add datafile autoextend
SQL
3 votes295 views1 answer
Uppercase and lowercase in sql
SQL
0 vote273 views1 answer
MySql get primary keys of table
SQL
5 votes312 views1 answer
Sql table columns
SQL
3 votes265 views1 answer
What is having clause
SQL
1 vote302 views1 answer
Sql string function update replace
SQL
0 vote292 views1 answer
How to get data from 2 database
SQL