title: Get extension of a file using SQL?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1226789/get-substring-in-sql-server">Get substring in SQL Server</a>  </p>
  </blockquote>
  
  
  
  <p>Let's say I have <code>MyImage.png</code> or <code>MyDoc.doc</code>, etc in a column in a database table. </p>
  
  <p>How can I only get the file extension?</p>