Subject RE: [IBO] Concatenate strings in result sets
Author Norman Dunbar
Try :

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

to get something like 'Norman Dunbar' etc.

Norman Dunbar EMail: NDunbar@...
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. Fax: 0113 201 7265

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

Steve Harp

Your use of Yahoo! Groups is subject to