How to do case insensitive SELECT?

[Ken Ray]

Hey,

I'm doing a query on a table that is retrieving all the records and
sorting on a field in the DB. When it comes back, the data is sorted by
ASCII value (I assume that is 'case sensitive') and I want it case
insensitive. Any suggestions? I don't have a WHERE clause so I can't use
the 'no case' option. Here's my query:

  SELECT RecID,FileAs FROM Entities ORDER BY FileAs

And my last two records are:

  7134 Zzyzyx Corp.
  836  cYclops Unlimited

As you can see, the "c" is sorting after the "Z" and not with the "C"s.

Any ideas?

Ken Ray
Sons of Thunder Software
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/