Hi,

 

in a trigger i want to conact the a value to a varchar. But that does not work - Unknown Column error -206

 

i have:

 

create trigger...

...

declare variable i integer;

...

...

i = 54;

   # fanr is Varchar(100)

   insert into (....) values(... , new.fanr || i);    # does not work

# or even

   insert into (....) values(... , new.fanr || cast(i as Varchar(10));   # does not work

 

   insert into (....) values(... , new.fanr || 342);   # works but not a variable!

 

How can i do this?