T-SQL: Get Filename from Filepath

Many times applications store operating system paths to files in the database. And sometimes need to get only Filename portion out of Filepath column in MSSQL. How to do that ?

Disclaimer: I know - it's much easier to get the filename using C#, however many times we need to get the list of filenames filtered/grouped by some criteria.

Since there is no split function analog in T-SQL - I will use SUBSTRING, REVERSE and CHARINDEX to manipulate strings:

SELECT REVERSE(SUBSTRING(REVERSE(@fpath), 0, CHARINDEX('\', REVERSE(@fpath), 1)))

Enjoy :)

Related Posts:

• MySql: Add a Column at a Specific Position
• MSSQL 2008: Spatial Data Types - Geography and Geometry
• MSSQL 2008: What is DATETIME2
• T-SQL: LIKE Operator and Wildcard Characters
• MSSQL: Search and Replace in a TEXT(NTEXT) column
• T-SQL: Get Age from Date of Birth
• MSSQL 2005 Tip: Using TOP with Subquery
• T-SQL Query Processing Order
• How to Insert DBCC Output into MSSQL Table
• MSSQL: sp_xml_preparedocument is not supported in fibers mode