SQL Interview Question:

You want to include a carriage return/linefeed in your output from a SQL script, how can you do this?

Submitted by: Administrator

Expected answer: The best method is to use the CHR() function (CHR(10) is a return/linefeed) and the concatenation function "||". Another method, although it is hard to document and isn?t always portable is to use the return/linefeed as a part of a quoted string.
Submitted by: Administrator