Getting the file extension on SQL Server

Today I had the need to get the extension of a file name I have stored on a table column.

Googled it a bit and ended wrapping the concepts I've found and making my own solution:

REVERSE(SUBSTRING(REVERSE('filename.pdf'), 0, CHARINDEX('.',REVERSE('filename.pdf'))))