Обсуждение: Form a field from two fields in a select

Hi.
How can i construct a field from two table fields in
a select clausule.
Something like this:

select (month + " " + year) as date from xxx;

from two fields month and year with they obvious values,
to obtain a string link this:

  102001

and not a number as 2011.

Thank you.

--
Manuel Cano Muñoz
------------------------------
SANYRES, S.A.
Director Dpto. Sistemas
manuel@sanyres.com
manuel@sanyres.es

manuel@des01.sanyres.es wrote:

> Hi.
> How can i construct a field from two table fields in
> a select clausule.
> Something like this:
>
> select (month + " " + year) as date from xxx;
>
> from two fields month and year with they obvious values,
> to obtain a string link this:
>
>   102001
>
> and not a number as 2011.

SELECT month || year as date FROM xxx;