Is there any Line Feed and Carriage Return in SQL script? It is something
like VBCrLF or chr(10). Thanks.I'd do something like this:
declare @.CRLF char(2)
set @.CRLF = char(10) + char(13)
--Jason
"Sean" <Sean@.discussions.microsoft.com> wrote in message
news:550D5201-EC23-4CC8-8A12-3818BED19890@.microsoft.com...
> Is there any Line Feed and Carriage Return in SQL script? It is something
> like VBCrLF or chr(10). Thanks.|||Char(13) = Carriage Return
Char(9) = tab.
select 'New line' + char(13) + 'after LF ' + Char(9) + ' after tab'
"Sean" wrote:
> Is there any Line Feed and Carriage Return in SQL script? It is something
> like VBCrLF or chr(10). Thanks.
No comments:
Post a Comment