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

<br/> 
I am trying to print a tab in sql server using :<br/>
select 'tab-->' + char(9) + '<--tab'<br/>
But it doesn't seem to work and always prints <br/>
tab--> <--tab<br/>
Is there any thing I am missing ? 

Thanks
Rakesh Singh