Thread: SQL question

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
----------------------------------------------------------------

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