blank lines

This may be an incredibly easy fix, but I can't figure it out!

I'm working with xp_sendmail, and I'm trying to get it send out 2 separate queries.

The problem is that in the body of the e-mail, it puts the right after each other, so it's kind of bad to look at.

Is there any way I can insert a few blanks lines in between these 2 queries ? I tried a simple "print ' ' ", but I get access violation errors.

Suggestions?Well, this may not be an elegant solution, but you can always place a few statements like:

select ''

between your queries to add some blank space. Actually, this may print line separators defpending on your connection configuration, but you can also try something like this:

select char(13) + char(13) + char(13) + char(13) + char(13)

...which will pad your output with five carriage returns.

blindman|||Well that works, but as you said, the line separator shows up, which is kind of an eyesore. Do you or anyone else know any workarounds to this?|||Use the Char(13) method and you can include as many line-feeds as you want and you should only get one separator for the statement.

blindman