Christopher,

You have to use || for concatrenating.

ie:
SELECT
LAST_NAME || ', ' || FIRST_NAME AS FULL_NAME
FROM
SALESMAN

Luc.

"Christopher P. Boothe" schrieb:

>
> How come this doesn't work?
>
> SELECT
> LAST_NAME + ', ' + FIRST_NAME AS FULL_NAME
> FROM
> SALESMAN
>
> The sql works from my paradox app but not when I convert it to Interbase and
> put the statement in an IBX query.
>
> Isn't that pretty standard SQL?
>
> Thanks for your help.
> Chris
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/