Delphi TQuery and Order By sql command

I working in Delphi 2, Using Paradox 5 tables and local sql. I am doing
a complex join (data from 2 tables) and I am using a TQuery Object. The
sql looks like the following;

select, from table1 a, table2 b
where =
order by name, date desc

The query works fine but the sort is a follows

Name = A thru Z then a thru z  (ascii)

I need to have it sorted

Name = A, a, thru Z, z

Does anyone know how to make this possible.


Sent via
Before you buy.