> 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.

Show us more please, what does the SQL trace monitor show?

My guess is the SQL parsing I do is messing it up.

I'll add this to my case of bugs to work out.

Regards,
Jason Wharton