Char(9) doesn't print tab in Sql server 2005

user_1546629 0
Viewed 18668

I am trying to print a tab in sql server using:

select 'tab-->' + char(9) + '<--tab'

But it doesn't seem to work and always prints

tab--> <--tab

Is there any thing I am missing?

char sql-server
4 Answers
  1. Tool -> Options -> Query Results -> SQL Server -> Results to Grid -> Retain CR/LF on copy or save
  2. Restart SSMS
user_53080540
Related