Sort Alphanumeric list of data, Right now i am using order by ASC. It shows numeric data first then showing alphabet. I need to show alphabetically first before numeric data.
Right now it is showing like this.
1 cat
2 dog
apple
ball
I need to show this like:
apple
ball
1 cat
2 dog