At 04:51 PM 7/04/2006, you wrote:

>FireBird 1.5
>I run EMS IBManager/IBExpert to execute the SQL:
>
>UPDATE OldDateTable
>SET Transaction_Date = ADDYEAR(Transaction_Date, 100)
>WHERE Transaction_Date < 1910
>
>I got 'function unkown' error: AddYear

It's an external function (UDF) in fbudf.dll. Do you have it
declared in the database?

./heLen