>>I found a situation I can't explain. I have the following SQL:
>>
>>

>>SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,1;
>> FROM THREAD WHERE NoClient=5 AND NUMERO>=600000;
>>UNION SELECT NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,0;
>> FROM THREAD WHERE NoClient<>5 AND NUMERO>=600000;
>> ORDER BY 11 DESCENDING,1,2,6,5 INTO CURSOR TEMP READWRITE
>>

>>
>>The only way to make that work is to use an ORDER BY clause with numeric references. As soon as I put the UNION clause in it, I am forced to use numeric references for the SQL. Why is that?
>
>Michel,
>Would this be an alternative solution ?
>

SELECT distinct NOCLIENT,NOCAT,NUMERO,NOMEMBER,NOPARENT,;
>  NOTHREAD,ADDDATE,ADDHEURE,TITLE,.T. AS FLAG,iif(NoClient=5,1,0) as myExp ;
> FROM THREAD WHERE NUMERO>=600000 ;
> ORDER BY 11 DESCENDING,1,2,6,5 INTO CURSOR TEMP READWRITE
>

Cetin

BTW forcing to numeric values should be related with you have an expression in order by.
Cetin