to concat first and last name

[arravalli12]

I want to concat first and last name from table a with space between eg; john smith. This works good in oracle but I do not know how this works in ansi sql..

The query is: select concat( firstname, lastname) from A.
My result should be John smith.

Can any one help me out...
thanks

 

[mrdenny]

Like this.

select firstname + ' ' + lastname
from A

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[arravalli12]

Thanks Denny. This worked perfectly. So simple but lack of knowledge on my side.
Thanks once again...

 

[r937]

uh, i hate to be a stickler, but that's not ansi sql, that's sql server sql

ansi sql is

firstname || ' ' || lastname

;-)


rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts July 10 2005)

 

[mrdenny]

Sorry, force of habit.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)