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 a.name, b.date from table1 a, table2 b
where b.id = a.id
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.

Thanks...

Sent via Deja.com http://www.deja.com/
Before you buy.