OBJECTIVE:

To find the document extension from sql server table column if the column does have filename along with extension.

QUERY:

SELECT TOP 10 PATINDEX(‘%.%’, DOC_FILENAME) AS DOC_FILETYPE_POSITION,SUBSTRING(DOC_FILENAME,PATINDEX(‘%.%’, DOC_FILENAME),LEN(DOC_FILENAME)) AS DOC_FILETYPE FROM [DBO].[DOCUMENT] (NOLOCK)