Without literal
SELECT EMPNO || ENAME EMPLOYEE
FROM EMP;
With literal
SELECT EMPNO || '-' || ENAME EMPLOYEE
FROM EMP;
SQL Server: + operator
SELECT EMPNO + '-' + ENAME EMPLOYEE
FROM EMP;
Sunday, April 5, 2009
Concatenation Operator
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment