Query Designer

rbuser

In the Query Designer I want to add a field that
is the result of the concatenation of two fields..
How can I do?

( myFieldName1 || myFieldName2 ) as myField

Raf

digitalmetaphors

Create a calculated field. Select the Calcs tab of the data view, double
click a field, select Expression for function type and enter Field1 + ' ' +
Field2 for the Expression.

--
Cheers,

Alexander Kramnik
Digital Metaphors