Escaping '&' in WebDAV sql query
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
Hi guys, I'm using WebDAV to send sql search queries to Outlook exchange atm and am experiencing problems with '&' character. When '&' appears in the search string (eg 'OH&S'), no results would be returned. I've also tried 'OH&&S' AND 'OH&'||'S', but had no luck. eg. string searchString = "OH&S"; string searchQuery = "SELECT \"DAV:href\", \"urn:schemas:httpmail:subject\", \"urn:schemas:httpmail:from\", \"urn:schemas:httpmail:date\" FROM SCOPE('SHALLOW TRAVERSAL OF \"http://xx/xx\\"') WHERE CONTAINS(*, '\"%" + searchString + "%\"')"; Any help would be much appreciated. Thank you.