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, Dmitry Yemanov <dimitr@u...>
wrote:

> 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