Standard SQL syntax will not parse the xml for you. Here is a sample of how to incorporate the CLR in sql server.
Storing blocks of xml is fine if you just want to retrieve it. Otherwise, it is very
poor design if you need to parse that xml as part of a WHERE clause in a query.