SQL - blank line?

[SQLScholar]

Hey all,

I am guessing i know the answer to this will be no, but i have been wrong many times in the past.

I am doing a query that is reasonably complex - and is nearly on what i think the limit is for unions (if i do a few more i get an error).

Anyway - is there anyway to do a blank line without doing a select '','','','','','','',''...
from x

TIA

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[hneal98]

You can use PRINT.

 

[hneal98]

Sorry, ignore the previous message. I thought it was SQL Server. Anyway, where are you trying to do this blank line? Is it in a report? If so, you can make the blank line by putting extra space in the detail section or one of the groups based on where you are wanting the space.