Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Query to remove the string between two indexes of delimiters
-- Query to remove the string between two indexes of delimiters DECLARE @NameString VARCHAR(MAX) = 'Suman,Saurav,Rajeev,Chandra,Mizan,Ahmed', @StartIndex INT = 0, @EndIndex INT = 21 SELECT STUFF(@NameString, CHARINDEX(',', @NameString, @StartIndex), CHARINDEX(',', @NameString, @EndIndex) - CHARINDEX(',', @NameString, @StartIndex), '')
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
sql_fb
SUPPLIER
remove duplicated rows
for xml path concatenation ordered by seqno
SQL_Joins_RankingFunctions
megha
Create Index On Viiew
Null as default value
MSSQL NVARCHAR to INT conversions
Solution 4
Please log in to post a comment.