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

Luiz.

----- Original Message -----
From: Steve Harp <steve@...>
To: <ibobjects@yahoogroups.com>
Sent: Monday, July 02, 2001 1:27 PM
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/
>
>