InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 23:49:08 GMT20http://www.sqlservercentral.com/Forums/Topic798676-8-1.aspx[font="Arial"]I add the same problem with SQL Server : "something"+char(9)+"something"returns something something "something"+char(9) + char(9)+char(9)+char(9)+char(9)+char(9)+"something"returns something somethingfinally, I "cheated" with : [b] "something"+char(9)+char(160)+char(9)+char(160)+char(9)+char(160)+char(9)+char(160)"something"[/b][b]returns something [8 spaces here] something [/b] (each char9 or char16 is replaced by a space)so visually I got what I wanted, even if I admit it is not very elegant...[/font]Wed, 13 Mar 2013 04:44:49 GMTemich11-reseauhttp://www.sqlservercentral.com/Forums/Topic798676-8-1.aspx[quote][b]RD-201664 (10/6/2009)[/b][hr]select 'there should be a tab between here' + char(9) + 'and here'Ideas?[/quote][code="sql"]declare @result varchar(100)set @result = 'TEST START'+char(9)+'EXEC'+char(9)+'TEST END'select @result[/code]RESULTTEST START EXEC TEST END[code="sql"]set @result = replace(@result,char(9),' -TAB HERE- ')select @result[/code]RESULTTEST START -TAB HERE- EXEC -TAB HERE- TEST ENDTue, 06 Oct 2009 21:26:56 GMTarun.sashttp://www.sqlservercentral.com/Forums/Topic798676-8-1.aspxAhh, I was only looking in QA then copy/paste to Notepad. The finished output does have the tab.Thanks.Tue, 06 Oct 2009 11:06:21 GMTRD-201664http://www.sqlservercentral.com/Forums/Topic798676-8-1.aspxWhat are you using to verify that you only get a space? You're not going to see it in QA or SSMS, as they don't show things like carriage returns/tabs/etc. If you select that cell into a front end that does display those things, it may work fine.Tue, 06 Oct 2009 10:56:43 GMTGaradinhttp://www.sqlservercentral.com/Forums/Topic798676-8-1.aspxHi all,This is for SQL 2000. I am trying to add a tab character to a string using char(9) but all I get is a single space.Example:select 'there should be a tab between here' + char(9) + 'and here'Ideas?Thanks.Tue, 06 Oct 2009 10:40:39 GMTRD-201664