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

You click the "reply" link in the top right of the post =)


Mmm... afraid I don't know MSSQL :(

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!