Svein Erling Tysvaer wrote:

> I tried changing the names a bit to make it easier for me to understand:
>
> create table MILAN ( BABUSKOV INTEGER );

LOL :)

> SET TERM ^ ;
> CREATE TRIGGER NEW_BU2 FOR MILAN ACTIVE BEFORE UPDATE POSITION 0 AS
> BEGIN
> select MILAN.BABUSKOV from MILAN

My initial idea even used alias to complicate things even further ;)

select new.old from new old
where old.old = new.old
etc.

--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org