Sometimes you want to make your HTML source code more readable, or insert consistent indents into non-HTML elements like an e-mail. You can that with either of the two following commands:
<% Response.Write(vbTab) ' or Response.Write(CHR(9)) %> |
To embed a TAB character into results coming out of SQL Server (e.g. for use in a tab-delimited text file based on a recordset), you can do this:
| SELECT 'Tab-->' + CHAR(9) + '<--Tab' FROM table |
Keep in mind that this output will not look the same in HTML as it does in View Source, notepad or Query Analyzer.