Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Escape sequences for SQL string
Message
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00800907
Message ID:
00801133
Views:
22
>For single quote, you don't need to use escape sequence. Just replace one single quote with two single quotes (not double quote). For example,
>

Great, that seems to take care of single quotes. What about double quotes? How should they be handled? I tried (and a few variations on this):
strnewLine = strLine.Replace("\"", @"\" + '"');
But, SQL chokes.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform