Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: Parser of new line Tab GO within string fail
Message
 
 
To
23/10/2004 03:29:58
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00953766
Message ID:
00954123
Views:
17
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'
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform