Try :

Select FirstName || " " || LastName As FullName from Person;

to get something like 'Norman Dunbar' etc.

Regards,
Norman.
----------------------------------------------------------------------------
----
Norman Dunbar EMail: NDunbar@...
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. Fax: 0113 201 7265
URL: http://www.LynxFinancialSystems.com
----------------------------------------------------------------------------
----


-----Original Message-----
From: Steve Harp [mailto:steve@...]
Sent: Monday, July 02, 2001 5: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/