MSSQL – get file extension from file name

 select (case when FileName like '%.%' then reverse(left(reverse(FileName), charindex('.', reverse(FileName)) - 1)) else '' end) as File_Extension

source: https://stackoverflow.com/questions/16783026/t-sql-get-file-extension-name-from-a-column

This entry was posted on Saturday, February 25th, 2023 at 1:21 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.