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

[Solved] Split a string in SQL Server

Adnaan

Adnaan

SOLVED CLOSED ACTIVE ANSWERED
User: Adnaan
Posted: on Feb 06, 2025 12:23 AM
Forum: SQL Server
Answer: 1
Views: 983

Hi,

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

Please guide.

Mudassar

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Feb 06, 2025 12:29 AM
Modified: on Feb 06, 2025 01:30 AM
Report

Try the following SQL

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

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2026 ASPSnippets.com ALL RIGHTS RESERVED.