title: Where clause when using XML in SQL
body: <p>I am currently using a XML data type in a SQL table</p>
  
  <p>My datatable looks like this</p>
  
  <pre><code>Id | Name | Surname | Title  | Location | Artist |
  -------------------------------------------------------
  1  | xxx  | abc     | def    | London   | XML    |
  2  | xxx  | abc     | def    | Oslo     | XML    |
  3  | xxx  | abc     | def    | New York | XML    |
  </code></pre>
  
  <p>My XML file looks like this</p>
  
  <pre><code>&lt;song category="gaming"&gt;
  &lt;title&gt;Valentine's Day&lt;/title&gt;
  &lt;artist-main&gt;Fatfinger&lt;/artist-main&gt;
  &lt;artist-featured&gt;Slimthumb&lt;/artist-featured&gt;
  &lt;year&gt;2013&lt;/year&gt;
  &lt;price&gt;29.99&lt;/price&gt;
  &lt;album&gt;Gamestain&lt;/album&gt;
  &lt;albumimg&gt;http://download.gamezone.com/uploads/image/data/875338/halo-4.jpg&lt;/albumimg&gt;
  &lt;songurl&gt;http://www.youtube.com/watch?v=-J0ABq9TnCw&lt;/songurl&gt;
  </code></pre>
  
  <p></p>
  
  <p>Now to get the record depending upon the artist I am using a query which is</p>
  
  <pre><code>SELECT 
  Id, Name, Surname, Title 
  FROM 
  DATA 
  WHERE 
  Artist Like '%Fatfinger%' -- (this is user input)
  </code></pre>
  
  <p>Is this is the right approach in querying XML data in SQL or are there any built in functions in SQL that can handle XML. I am new to SQL.</p>