SDU Tools 153 File Path Components
SDU Tools are free tools and provide example T-SQL code for SQL Server developers and DBAs. There is often a requirement to work with file paths in T-SQL. The FilePathComponents function takes a full file path, and extracts the folder path, the file name, and the file extension.
To join SDU Insiders and get all our free resources, including SDU Tools, see the details at http://sdutools.sqldownunder.com