FINDING DOCUMENT EXTENSION FROM SQL SERVER TABLE

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].[DOCUMENTS] (NOLOCK)