concatenate string firebird

The reason is that + is not SQL standard operator for string concatenation. It is ||. Example:
select first_name||' '||last_name from employee;