title: Remove extensions from filename
body: <p>I'm using SQL.</p>
  
  <p>In a table tblDemo,one of the column is 'FileName'. Each row of this column contains a different filename with any extension.
  For ex. 'flower.jpeg', 'batman.mov', study.pdf etc.</p>
  
  <p>Please suggest me on a query which could help me to remove the extension(and dot as well) from each row of the 'filenames' column. So that I could fetch only the name Ex. 'flower', 'batman', 'study' etc.</p>
  
  <p>Thanks</p>