String.LastIndexOf, but in T-SQL (handy for getting file extensions)

Mar 09, 2020
t-sql
1 min read

Note that this doesn’t work on the “text” datatype, so you’ll need to cast to nvarchar…


SELECT  LEN(FileName) - CHARINDEX('.', REVERSE(FileName)) AS ‘LastIndex’,
        RIGHT(FileName, CHARINDEX('.', REVERSE(FileName))) AS ‘FileExtension’ – still includes the dot
FROM    Files