> I know it can be done, but I cannot seem to figure out how to output to
> fields concatenated together in a select. For instance, I have a table
> with first_name and last_name as fields (among others). I would like
> display first_name and last_name as one field. I want to do something
> like:
>
> name=first_name + " " + last_name
>
> but of course within an SQL select statement. Thanks...james
Sorry, I finally found it in the hackers mailing list. The answer is:
select textcat(textcat(first_name, ' '),last_name) from users;
I just couldn't seem to find that documented, I am sure it is though.
Thanks...james