Hi, dont know how to reply to post so im writing it again . Sorry Andy

hi, I have a problem with the sort order in MS SQL, I have record displaying like, this how MSSql sorts the records by code. Numbers comes before letters.

code description
A13A xxxxxxx
A14A xxxxxxx
AAAA xxxxxxx
AAAB xxxxxxx

I want the records sorted by code but in epsidec format, like characters will come first before numbers. I've been reading about collation but really cant figure it out. Can someone help me on how to do this? PLs.

I want the output to be like this,
code description
AAAA xxxxxxx
AAAB xxxxxxx
A13A xxxxxxx
A14A xxxxxxx