Give this a go, replace [Path] with the name of your field and [Files] with the name of your table
SELECT
CASE WHEN CHARINDEX('.',REVERSE([Path])) > 1 THEN LEFT([Path], LEN([Path]) - CHARINDEX('.',REVERSE([Path]))) ELSE [Path] END AS FileNameWithoutExtension
FROM
[Files]