|Subject||RE: [Firebird-general] Expression Evaluation not supported + ' ' +|
> Hello,Use the double pipe to concatenate strings.
> 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.
select firstname || ' ' || lastname as name
And, please take support questions to the firebird-support
For a full list of available newsgroups visit:
The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird