Thanks a lot. It solved my problem.
Actually, I am new to Firebird. But I liked the way it works.
Thanks again.
Regards,
Ghanshyam

--- In Firebird-general@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> > 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