Plz Help

need a sort query for columns which has in one row alpha characters and another row number i need to order it as
abcd
2
3
4
etc
can u help me out

Thanks
Anupama

what's the problem with using "order by" as part of the select statement?

Also, please use more descriptive Subject's for your posts.