Firebirdsql concat fields code example

Example: 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;