At 10.55 09/11/2001 +0100, you wrote:

>Hello,
>
>a select like 'select cast('234' as integer) from ...' in IB_SQL results in
>an error 'Fieldname: not found'.
>In IBConsole it doesn't.
>Giving an alias like 'select cast('234' as integer) dummynumber from ...'
>helps.
>
>Greetings Dieter Tremel

I encountered in this problem too use

>select cast('234' as integer) as fieldname from ...

it will work.
Regards
Marco Lauria
STARMAX s.a.s.