Last post Aug 09, 2016 05:35 AM by Fei Han - MSFT
Aug 08, 2016 12:24 PM|ykkumar13|LINK
I am inserting data in a column with slash separation. For example AA/DD/CC/FF, Here I want to retrieve in SQL with slash separation in to strings like A=AA,B=DD,C=DD,D=FF
Aug 09, 2016 05:35 AM|Fei Han - MSFT|LINK
According to your description, it seems that you’d like to split a string (field value), the following links could be helpful.
https://msdn.microsoft.com/en-us/library/mt684588.aspx (STRING_SPLIT function)
(explained how to use the Split function to split a string in a SQL Query or Stored Procedures)