|Subject||RE: [IBO] "order by coalesce" problem|
> If I put SQL sentence likeif you change it to
> "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.
select coalesce(field1, field2), * from table order by 1
it should work ok