Thread

1. Form a field from two fields in a select

   manuel@des01.sanyres.es — 2001-05-16T09:29:37Z

   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
   
   

2. Re: Form a field from two fields in a select

   Alexander Dederer <dederer@spb.cityline.ru> — 2001-05-16T11:35:06Z

   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;