If you are working in a database that has asset/file storage and need to get just the extension of the column this query will help save time.
SELECT CASE WHEN filepath LIKE '%.%' THEN RIGHT(filepath, Len(filepath) - Charindex('.', filepath)) ELSE filepath END FilePath FROM tbl1
Last Updated on October 26, 2015