sql query

Question

is there any query in sql to print next line like:-
abc
xyz

Answer 1

Can you please give more information about what you are trying to achieve?

Answer 2

is there any query in sql to print next line like:-
abc
xyz

You can use the carriage return or line feed to achieve this.

Something like..

PRINT 'abc' + CHAR(10) + 'xyz'
or
PRINT 'abc' + CHAR(13) + 'xyz'

It does not work with a SELECT - The CHAR(10) and CHAR(13) simply converts to a space..ie...abc xyz.

---

Clive
http://www.sqlsvrdba.com