MySQL:
select concat(ename, ' is a ', job) from emp;
Oracle:
select ename || ' is a '|| job from emp;
SQL Server:
select (ename + ' is a ' + job) from emp;
select concat(ename, ' is a ', job) from emp;
Oracle:
select ename || ' is a '|| job from emp;
SQL Server:
select (ename + ' is a ' + job) from emp;