hi, I have a problem with the sort order in SQL, I have record displaying like
code description
A13A xxxxxxx
A14A xxxxxxx
AAAA 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.
code description
A13A xxxxxxx
A14A xxxxxxx
AAAA 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.