Select join 2 fields

sql select statement query

[firdzak]

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]

select firstname+' '+lastname as name from person

[firdzak]

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

[ZydoSEO]

Try the following:

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

[firdzak]

thanks zydo
it works well