Subject Trigger SQL
Author slsolutions2002
Hello:

I am using Interbase. I am tring to create a trigger that will take a
customers first and last names and combine them as follows:

Set Term !! ;
Create Trigger tgUpdateFullName For Customers
After Update
Position 0
As
Begin
New.FullName = New.LastName + ' ' + New.FirstName;
End !!
Set Term ; !!
Commit;

I get an error message that tells me the calculation is sunsupported.
Can someone tell me the proper SQL.

Thanks Geno