Form a field from two fields in a select
Started by Nonamealmost 25 years ago2 messagesgeneral
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
Re: Form a field from two fields in a select
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;