Is there any way to do this (ingres) sql in firebird? Short of an SP I can't
think of one.

EXEC SQL UPDATE tt_spirit_02 t
FROM bx_house_tillmod_excpt b
SET bx_modifier_code = b.bx_modifier_code,
join_made = 'Y'
WHERE b.outlet_no = :l_cur_hse
AND b.bxp_code = int4(t.item_code)
AND b.till_modifier_code = int4(t.modifier_code);

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly