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