Extract from delimited string

Asked Aug 23 '21 at 16:06

Active Aug 23 '21 at 16:08

Viewed 42 times

I have a sample delimited string mentioned below:

abc-def-ghi-jkl-mnop-qrstu-vwz-yz

I want to extract the each value from the mentioned string like abc,def etc as a separated column. Could you please help me with the MSSQL server query to extract the values from string.

We have limitation that we can only use CHARINDEX and SUBSTR.

Expected output:

asked Aug 23 '21 at 16:06

Rajesh Kumar

Take a peek at https://stackoverflow.com/questions/68009828/sql-split-string-into-columns/68009909#68009909 – John Cappelletti Aug 23 '21 at 16:21

Extract from delimited string

0 Answers0