حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

[Solved] Split a string in SQL Server

Adnaan

Hi,

I have file name such as MadDog.jpg, I need to split it to get the extension in SQL Server.

Please guide.

Mudassar

0 1

Try the following SQL

SELECT [value] 
FROM STRING_SPLIT('MadDog.jpg', '.');

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html