Re: Easy SQL Question

You can do it like this:

select firstname || ' ' || lastname as fullname from emp;

/Shoaib

On 6/12/06, Greg <greg(at)officium(dot)co(dot)za> wrote:
>
> I Was looking at the PgSQL documentation last night but could not find how
> to join two fields as one,
>
> i.e
>
> select (firstname + lastname) as fullname from users
>
> I also tried (Cast(firstname as varchar) + Cast(lastname as varchar))
>
> But that doesn't work..
> How do I do this?
>
> Thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>