i have a table called Names, where the data is stored like
Raju;
Rakesh;
Preema;
Swetha;
+9199869986;
+9145899656;
+9177885555;
Testing;
Doggy;
Now, if i need to sort by name, i tried like this
"SELECT * FROM namesTable ORDER BY tblNames ASC"
Here i'm getting numbers first, i want numbers to be at the end actual letters from A should appear first.
Any help
Aucun commentaire:
Enregistrer un commentaire