How to remove the file suffix contained in the file name data in the SQL SEVER table

--Create a table

Create Table Filenames

(

Filename Varchar (+) NOT NULL

)

--insert test data with three different suffix names

SELECT * FROM Filenames

INSERT INTO Filenames

Values

(' Wahtisup.doc ')

INSERT INTO Filenames

Values

(' etstahaha.elsx ')

INSERT INTO Filenames

Values

(' shendong.html ')

---function implementation

--The REVERSE function arranges the string order of the filename column from right to left

--CHARINDEX ('. ', REVERSE (filename)) finds the suffix in reverse order. Specific locations that appear

---right (filename, charindex ('. ', REVERSE (filename)) to find out the specific suffix name of each column

--The Replace function replaces the suffix name with null

Select REPLACE (filename, right (filename, charindex ('. ', REVERSE (filename))), ") from Filenames

How to remove the file suffix contained in the file name data in the SQL SEVER table