How can i escape special characters( % [ _ ) in an Access SQL statement?
- From: "forest demon" <mete.hanap@xxxxxxxxx>
- Date: 27 Nov 2006 14:38:16 -0800
i need to escape characters, such as ( % and/or _ and/or [ ),
since i have database entries that have such characters in them.
the following piece works fine in an SQL statement (c#), but doesn't
return entries that have one of the above characters in the argument.
... like '%" + tbProduct.Text.Replace("'", "''") + "%' ...
thanks folks...
-¿-
.
- Follow-Ups:
- Re: How can i escape special characters( % [ _ ) in an Access SQL statement?
- From: Anders Borum
- Re: How can i escape special characters( % [ _ ) in an Access SQL statement?
- Prev by Date: Re: Add C code to my C# application?
- Next by Date: Focus-Lost Problem
- Previous by thread: Web Application Data Extraction
- Next by thread: Re: How can i escape special characters( % [ _ ) in an Access SQL stat
- Index(es):