> If I put SQL sentence like
> "select * from table order by coalesce(field1, field2)"
> into TIBOQuery, I got error:
> Dynamic SQL Error SQL error code = -104 Token unknown - line 4, char
> 30 ASC
>
> I tryed same sentence in IBExpert, and works fine.
>
> Thanks for help.
>
> Matej

if you change it to
select coalesce(field1, field2), * from table order by 1
it should work ok
Alan