sql - How do I split a delimited string so I can access individual ...
Nov 2, 2015 · Using SQL Server, how do I split a string so I can access item x? Take a string "Hello John Smith". How can I split the string by space and access the item at index 1 which …
How to split strings in SQL Server - Stack Overflow
How to split strings in SQL Server Asked 14 years, 5 months ago Modified 6 years, 1 month ago Viewed 88k times
sql - How do I split a string into 2 parts based on a delimiter ...
10 One option here is to make use of SQL Server's base string functions SUBSTRING() and CHARINDEX() to split apart the two parts of Field1 on the pipe character.
sql server - T-SQL split string - Stack Overflow
Jun 6, 2012 · I have a SQL Server 2008 R2 column containing a string which I need to split by a comma. I have seen many answers on StackOverflow but none of them works in R2. I have …
sql server - Turning a Comma Separated string into individual rows ...
Basically split my data at the comma into individual rows? I am aware that storing a comma-separated string into a relational database sounds dumb, but the normal use case in the …
sql server - Split a dynamic comma delimited string by fixed length ...
May 10, 2025 · For splitting T-SQL, cut string into chunks of 35 characters without cutting words appears similar. And Split string in SQL Server to a maximum length, returning each as a row.
Split a string at a specific character in SQL - Stack Overflow
The 3 parameters are the string to be split, the delimiter, and the part/substring number (starting from 1) to be returned. So if you have a field named string that contains stuff like AB_XXX and …
T-SQL split string based on delimiter - Stack Overflow
Feb 14, 2014 · I just wanted to give an alternative way to split a string with multiple delimiters, in case you are using a SQL Server version under 2016. The general idea is to split out all of the …
sql - How to split a comma-separated value to columns - Stack …
May 14, 2012 · STRING_SPLIT() is only really useful in SQL Server 2022 and above with the use of the enable_ordinal = 1 option. The STRING_SPLIT() results can then be used with a PIVOT …
How to split a string after specific character in SQL Server and …
Feb 13, 2012 · 2 I know this question is specific to sql server, but I'm using postgresql and came across this question, so for anybody else in a similar situation, there is the split_part(string …