RD-201664 (10/6/2009)
select 'there should be a tab between here' + char(9) + 'and here'Ideas?
declare @result varchar(100)
set @result = 'TEST START'+char(9)+'EXEC'+char(9)+'TEST END'
select @result
RESULT
TEST STARTEXECTEST END
set @result = replace(@result,char(9),' -TAB HERE- ')
select @result
RESULT
TEST START -TAB HERE- EXEC -TAB HERE- TEST END