Thread

1. SQL question

   Travis Bauer <trbauer@indiana.edu> — 2000-07-10T10:37:09Z

   Is it possible to return a column in an sql statement which concantenates
   two other columns and adds some other characters.  For example:
   
   create table t1 (x int, y int);
   insert into t1 values(1,2);
   select ???? as nifty from t1;
   
   nifty
   -----
   1/2
   
   What should I put in for the ???? ?
   
   ----------------------------------------------------------------
   Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
   ----------------------------------------------------------------
   
   
   

2. Re: SQL question

   NRonayette <r97m10@socotec.fr> — 2000-07-10T12:27:43Z

   
   Travis Bauer a écrit :
   > 
   > Is it possible to return a column in an sql statement which concantenates
   > two other columns and adds some other characters.  For example:
   > 
   > create table t1 (x int, y int);
   > insert into t1 values(1,2);
   > select ???? as nifty from t1;
   > 
   > nifty
   > -----
   > 1/2
   > 
   > What should I put in for the ???? ?
   
   select t1.x||'/'||t1.y from t1;
   
   this should work. If you can't concatenate int with char (t1.x with
   '/'), you must use a function to convert int in char If "to_char" is the
   name of this function, ???? became : to_char(t1.x)||'/'||to_char(t1.y)
   
   Nicolas