At 09:17 AM 25-06-01 -0500, you wrote:

>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?

No, it is a Microsoft vendor-specific convention. Standard SQL uses the double-pipe || as the concatenator. Try it, you'll like it. <g>

LAST_NAME || ', ' || FIRST_NAME AS FULL_NAME

Cheers,
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________