Ghanshyam,

> When i am trying to execute the following query, i am getting the
> error "Expression Evaluation not supported"
>
> select firstname + ' ' + lastname as name from Employee
>
> I think firebird doesn't support + ' ' + syntax.
> If it is so, then is there any UDF or any other way for the same.

The standard SQL syntax for a concatenation is the double pipe symbol:

select firstname || ' ' || lastname as name from Employee

P.S. Please post your support questions to the appropriate forum
(firebird-support).


Dmitry