Hi,

> The database is readonly and distributed on a CD and the search criteria
> varie according to what my customers want to search for. So I can't create
> a query. Is there a way to order the results without an query ?

I believe it can be done with:

ORDER BY 1 (or other column ordinal).

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com