Fetch filenames from filepath in column

Fetch Filenames from Filepath stored in column SQL

SELECT REVERSE(SUBSTRING(REVERSE(filepath), 0, CHARINDEX('\', REVERSE(filepath), 1))) from xpatientnotes

 

Leave a Reply

Your email address will not be published. Required fields are marked *