Single and Double Quotes

, ,
1

In an XQuery statement how do you filter single and double quotes for the parameters that are passed.

Currently I’m enclosing my parameters in single quotes because when I build the statement in C# I use double quotes to create the query string.

For example if somebody was looking in the database for a movie like {A Bug’s Life} or {Movie “Nick Name” Title}. Any suggestions would be helpful.

Thanks

2

You can represent embedded single or double quotes by using their respective character references, e.g.


  • 'A Bug&apos;s Life'</pre><LI><pre class="ip-ubbcode-code-pre">"Movie "Nick Name" Title"