Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

String Split in Sql server If your sql Compatibility level Below 130

Home
Forums

String Split in Sql server If your sql Compatibility level Below 130

Ajay Kumar

Ajay Kumar

5yAsked Mar 25, 2021, 5:10 AM1.2k

Do You Know How To Split The Sting Using Sql Server ,If Your Sql Server Compatibility level is Below 130

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Rajanikant Hawaldar5y ago
i think you should use XML method below is just sample
SELECT Split.a.value('.', 'NVARCHAR(MAX)') DATA
FROM
(
    SELECT CAST(''+REPLACE(@ID, ',', '')+'' AS XML) AS String
) AS A
CROSS APPLY String.nodes('/X') AS Split(a);
Output
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Jaimin Shethiya5y ago
Hello Ajay,

try below query and checked the your database Compatibility level

SELECT compatibility_level FROM sys.databases WHERE name = 'Your_Database_Name';

based on that you can check and split your string.

Thanks
Ajay Kumar5y ago
declare @nm varchar(50),@nm1 varchar(50),@devicenm varchar(50),@serialno varchar(50)
set @nm='Ajay__Abcd__65465465'
set @devicenm=''
set @serialno=''
SELECT @nm1=SUBSTRING(@nm, 0, CHARINDEX('__', @nm))
if(@nm1<>'')
begin
SELECT @devicenm= SUBSTRING(replace( @nm,@nm1+'__',''), 0, CHARINDEX('__', replace( @nm,@nm1+'__','')))
SELECT @serialno= Replace(SUBSTRING(replace( @nm,@nm1+'__',''), CHARINDEX('__', replace( @nm,@nm1+'__','')), len(replace( @nm,@nm1+'__',''))),'__','')
select @nm1 as 'NAME', @devicenm as 'DEVICE', @serialno as 'SERIAL NO'
end
else
begin
select @nm as 'NAME',@devicenm as 'DEVICE',@serialno as 'SERIAL NO'
end