SQL question

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