At 10:34 AM 15-12-00 +0100, you wrote:

>I am at release 3_6_C
>----------------------------------------
>1) I use a wwIBOTable,
>
>I would order a column with this option :
>'Upper(NFILE);Upper(Desc)' or
>with CaseInsFields "NFILE;DESC"
>
>Which is the best way to do this ?
>I don't want to create an index for this scope.

Well, it will be horribly slow but...

SELECT NFILE, DESC,
UPPER(NFILE) AS UPPERNFILE,
UPPER(DESC) AS UPPERDESC,
<OTHER COLUMNS...>
ORDER BY 3, 4

>----------------------------------------
>Where can I find IBObjects release level on my computer ?

Look at the Version property of the TIBODatabase or TIB_Connection.

H.

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________