Posted by John Bell on 09/06/05 11:20
Replied in Micorsoft.public.sqlserver.server please do not multi-post.
http://www.aspfaq.com/etiquette.asp?id=5003
http://www.aspfaq.com/show.asp?id=2081
http://www.aspfaq.com/etiquette.asp?id=5006
John
"Sathyaish" <sathyaish@gmail.com> wrote in message
news:1125988847.238366.259770@g47g2000cwa.googlegroups.com...
> What should one pass as a field value into a table in the insert
> statement if the value contained a percentage symbol (%) or the
> asterisk symbol (*), since both of these have special wildcard
> meanings. What if I want to pass the special meanings and pass them as
> literals? Is there any escape character that I must use? I am using
> ADO.NET v1.1 of the framework with VB.NET. The database is Microsoft
> SQL Server 2000.
>
Navigation:
[Reply to this message]
|