I have a table that has this as data

aa, Aa and AA

I would like to be able to sort on this row so I get

aa
aa
Aa
Aa
AA
AA

or the reverse, how do i go about this?

SELECT [Arow]
FROM [aTable]
ORDER BY [Arow]


I get them returned in the order they were entered into the db.

Cheers

Fragg