Hi,

> 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

Have you tried:
"('FG' || M1.FG) AS NewField" instead of "'FG' || M1.FG" ?

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)