<p>I'm using an Xml field in my Sql Server database table. I'm trying to search a word using the XQuery <strong>contains</strong> method but it seems to search <strong>only</strong> in case sensitive mode. The lower method isn't implemented on Sql Server XQuery implementation also.
¿Is there a simple solution to this problem?</p>

[{'answer_id': 71908, 'author': 'aku', 'author_id': 1196, 'author_profile': 'https://Stackoverflow.com/users/1196', 'pm_score': 0, 'selected': False, 'text': '<p><em><a href="http://www.google.ru/search?complete=1&amp;hl=en&amp;newwindow=1&amp;client=firefox-a&amp;rls=org.mozilla%3Aen-US%3Aofficial&amp;hs=MdF&amp;q=Sql+Server+contains+function+xquery+case-insensitive&amp;btnG=%CF%EE%E8%F1%EA&amp;lr=&amp;aq=f&amp;oq=" rel="nofollow noreferrer">First</a></em> link from google points to MSDN page:</p>\n\n<p><a href="http://msdn.microsoft.com/en-us/library/ms178026.aspx" rel="nofollow noreferrer">contains Function (XQuery)</a></p>\n\n<blockquote>\n  <p>In order to get case-insensitive\n  comparisons, the <a href="http://msdn.microsoft.com/en-us/library/cc645590.aspx" rel="nofollow noreferrer">upper-case</a> or\n  lower-case functions can be used.</p>\n</blockquote>\n'}, {'answer_id': 74594, 'author': 'JWHEAT', 'author_id': 7079, 'author_profile': 'https://Stackoverflow.com/users/7079', 'pm_score': 3, 'selected': True, 'text': '<p>If you\'re using SQL Server 2005, I\'m afraid you\'re out of luck.</p>\n\n<p>If you\'re using SQL Server 2008, you can use the upper-case function like this :</p>\n\n<pre><code>DECLARE @x xml = N\'abcDEF!@4\';\nSELECT @x.value(\'fn:upper-case(/text()[1])\', \'nvarchar(10)\');\n</code></pre>\n\n<p>Here\'s a link on MSDN for the upper-case syntax and a couple search examples :</p>\n\n<p><a href="http://msdn.microsoft.com/en-us/library/cc645590.aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/cc645590.aspx</a></p>\n'}]
['https://Stackoverflow.com/questions/71853', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/-1/']