title: Getting filename with out extension using SQL query in SQL server
body: <p>I have an issue while getting the file name with out extension from a column in SQL table like this.</p>
  <p>The column name is <code>[image]</code> in <code>dbo.emp</code> table and the values are:</p>
  <pre><code>temp.jpg
  test1.jpg
  test1.jpeg
  sample.jpg
  sample1.gif
  </code></pre>
  <p>Now I want to get only <code>temp</code>, <code>test1</code>, <code>sample</code>, <code>sample1</code> without the extension <code>.jpg</code>, <code>.jpeg</code>, etc…</p>