Extract (Get) string from String in SQL Server

baswal07

SOLVED CLOSED ACTIVE ANSWERED
User: baswal07
Posted: on May 21, 2020 08:47 AM
Forum: SQL Server
Answer: 1
Views: 1469

I want a specific string from main string like "18 - Dhanvantari Hospital-Koldam, Himachal Pradesh".

And i want only "Dhanvantari Hospital-Koldam"

I am looking for string between -(dash) and ,(comma)

Any idea how to do that in SQL or ASP.Net

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 3

Reply
ANSWER
User: dharmendr
Replied: on May 21, 2020 10:05 AM
Modified: on May 22, 2020 03:40 AM
Report

Check below query.

DECLARE @string VARCHAR(100) = '18 - Dhanvantari Hospital-Koldam, Himachal Pradesh'
SELECT SUBSTRING(@string,CHARINDEX('-',@string)+1,CHARINDEX(',',@string)-CHARINDEX('-',@string)-1)

SET @string = '7 - Stabilization Center-Gadarwara, Madhya Pradesh'
SELECT SUBSTRING(@string,CHARINDEX('-',@string)+1,CHARINDEX(',',@string)-CHARINDEX('-',@string)-1)

Output

Dhanvantari Hospital-Koldam

Stabilization Center-Gadarwara

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

Extract (Get) string from String in SQL Server

Company

Explore

Follow us

Contact Us