Creating a custom sort order

[Guest]

Hello

Is it possible and if so how can I create A custom sort order for a query

My specific question is I have a mixed listing and I want the query to sort it as follows

A0
A0
A0
B0
C0

Currently it returns
A0
A0
A0
B0
C0

Thanks in advance

Daniel

 

[Guest]

Try thi

SELECT Table1.Sor
FROM Table
ORDER BY LEFT(sort,1),Mid([table1].[sort],2) DESC;