File Extension

Posted on By David Kittell

If you are working in a database that has asset/file storage and need to get just the extension of the column this query will help save time.

SELECT CASE
		WHEN filepath LIKE '%.%'
			THEN RIGHT(filepath, Len(filepath) - Charindex('.', filepath))
		ELSE filepath
		END FilePath
FROM tbl1
Originally Posted on October 17, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL

Related Posts

VB.Net – Get File Size / Free Space / Total Space

Posted on

Private Function GetFileSize(ByVal MyFilePath As String) As Long Dim MyFile As New FileInfo(MyFilePath) Dim FileSize As Long = MyFile.Length Return FileSize End Function Public Function GetFreeSpace(ByVal Drive As String) As Long Dim lBytesTotal, lFreeBytes, lFreeBytesAvailable As Long Dim iAns As Long iAns = GetDiskFreeSpaceEx(Drive, lFreeBytesAvailable, lBytesTotal, lFreeBytes) If iAns >…

Read More

Format Zip Code Properly

Posted on

Sometimes a zip code is presented in a database with all nine numbers in the same column that has only five numbers. This query below will assist in formatting the numbers properly. SELECT CASE WHEN len(zip) = 10 AND substring(zip, 6, 1) = ‘-‘ THEN zip WHEN len(zip) = 5…

Read More

Powershell Download Script

Posted on

# If you haven’t already done so you will need to run this to be able to execute PowerShell scripts # You will need to run PowerShell as administrator to run this script set-executionpolicy remotesigned Pass variables to the script <# .SYNOPSIS Downloads one file from a defined URL to…

Read More