> Hello,
> 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.

Use the double pipe to concatenate strings.

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

And, please take support questions to the firebird-support
list (firebird-support@yahoogroups.com)

For a full list of available newsgroups visit:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_groups



--
Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com