> SELECT
> sales.*,
> (SELECT caption FROM sp_customer_caption(id_customer))
> FROM
> sales

it works in this way, but i do not like so many selects combined in one
result set.
And from my oppoint of view, it it much easier to read when it can be used
similar
to a udf.


--
See you on First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com

IBExpert - The most Expert for InterBase and Firebird --- www.ibexpert.com
HK Software - Holger Klemt - Huntestrasse 15 - D-26135 Oldenburg
Telefon Telefax +49 700 IBEXPERT (42397378) www.h-k.de
Schulungen - Projektunterst�tzung - Delphi - InterBase - AS/400