At 05:23 PM 11/02/2003 -0600, you wrote:

>FYI:
>
>I have a stored procedure that works but when I copy the select part and put
>it in a query statement in IB_SQL to test it I get an error. The error
>says: "Field name: not found"
>
>SELECT P1.COMPANY, CALL_DATE, M1.Trunk_id, M1.Carrier_id, 'FG' || M1.FG,
><===Error occures here

For alias server-computed columns you need to use the AS keyword and
provide an alias name:
'FG' || M1.FG AS Something,

Then the dataset will be able to handle it as a column.

Helen