SQL Server Print Blank Line Without Space

Question

In SQL Server 2005, I want to print out a blank line with the PRINT statement, however, when I run ``` PRINT '' ``` it actually prints a line with a single space. Does anyone know if it's possible to just print a blank line without the space? If I print a new line character, it doesn't print a space, but I end up with two new lines.

Accepted Answer

You could just add a newline on your previous print statement, if you have one.

Instead of:

```
PRINT 'BLABLABLA'
PRINT ''
```

You could write:

```
PRINT 'BLABLABLA
' <- the string finishes here!
```

SQL Server Print Blank Line Without Space

Solution

Problem