Try:

Select (FirstName || " " || LastName) As FullName from Person

But be aware that the whole expression is NULL when FirstName or LastName is
NULL

Thomas

> -----Original Message-----
> From: Steve Harp [mailto:steve@...]
> Sent: Monday, July 02, 2001 6:28 PM
> To: ibobjects@yahoogroups.com
> Subject: [IBO] Concatenate strings in result sets
>
>
> Hi All,
>
> I know this is easy, but I can't find a example of it. I need to combine
> FirstName and LastName into FullName.
>
> Select (FirstName, " ". LastName) As FullName from Person
>
> This doesn't work. What am I doing wrong?
>
> Thanks,
> Steve Harp
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>