Select join 2 fields

Forum Moderators: open

Message Too Old, No Replies

Select join 2 fields

sql select statement query

firdzak

3:14 pm on Feb 20, 2008 (gmt 0)

Hi all

I would like to know how to join 2 field to be in 1 field when u execute select statement

for example i have 'Person' table with this value:

FirstName LastName Address ID
Luke John 7777 2

if i execute 'select firstname,lastname from person; it will appear in 2 column. i want to appear this result in 1 column and that column type must be character.

Do anyone know how?

syber

3:29 pm on Feb 20, 2008 (gmt 0)

select firstname+' '+lastname as name from person

firdzak

3:32 pm on Feb 20, 2008 (gmt 0)

doest work lol.. sorry
for information i'm using postgres

ZydoSEO

6:44 pm on Feb 20, 2008 (gmt 0)

Try the following:

SELECT firstname ŚŚ ' ' ŚŚ lastname AS CombinedName
FROM person

firdzak

5:05 pm on Feb 24, 2008 (gmt 0)

thanks zydo
it works well