Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: Parser of new line Tab GO within string fail
Message
From
25/10/2004 11:16:09
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00953766
Message ID:
00954280
Views:
18
Hi Sergey,
you have to put a literal CHR(13) into the string:
SELECT *, ASCII(SUBSTRING(col1,3,1))
FROM ( SELECT 'b\
u' AS col1, 
		LEN('b\
u')  AS col2) dt1
>Hi Fabio,
>
>It seems to be fixed too. Here's query and result
>SELECT *, ASCII(SUBSTRING(col1,3,1))
>FROM ( SELECT 'b\' + CHAR(13) +'u' AS col1,
>		LEN('b\' + CHAR(13) +'u')  AS col2) dt1
>
>-- Result in the Text format
>col1 col2
>---- ----------- -----------
>b\
>u 4           13
>
>
>
>
>>Known you, if the other in string's bug it is fixed:
>>when a left slash followed by a CR it is put into a string,
>>the SQL Parser remove it:
>>SELECT 'blabla\CHR(13)blublu'
>>return 'blablablublu'
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform