<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>

First
link from google points to MSDN page:
contains Function (XQuery)
In order to get case-insensitive
  comparisons, the
upper-case
or
  lower-case functions can be used.