Marcel

Try this:

'Select a.MEMBERID, a.CHNAME || a.ENGNAME AS FULLNAME from MEMBSERS a'

The concatenated fields need to be assigned a single name.

Regards

Bob

--- In IBObjects@y..., "Marcel" <ibobjects@m...> wrote:
> Goodmorning,
>
> I am using D5ENT and IBO4.2Eb
>
> I key in this query in query editor 'Select a.MEMBERID, a.CHNAME ||
> a.ENGNAME from MEMBSERS a'
> This statement cannot prepare with Field not found error.
> But this query can prepare 'Select a.MEMBERID, a.CHNAME, a.ENGNAME
from
> MEMBERS a'
>
> Could anyone give me some advice?
> Thanks
> Marcel