V4MD: case insensitive ORDER BY

[Martin Pallett]

Hi,

this should be really easy, but I haven't been able to come up with the 
answer.

Here's what I want to do:

SELECT * FROM names WHERE recID >0 ORDER BY lastname asc, firstname asc 
no_case

which doesn't work, so I tried

SELECT * FROM names WHERE recID >0 ORDER BY upper(lastname) asc, 
upper(firstname) asc

which also doesn't work

Unfortunately, I can't force the case of the names stored in the table, 
and some of them are only a first name.

Is there an easy way to do this, or do I have to create duplicate fields 
in the database in all uppercase and order by them?

Thanks in advance for any suggestions.

Martin