asked on

Split Data in 1 column into 2 columns

In sql how can I split data in 1 column to 2 columns in Sql

Split the data which is before - and after - . some times data could only have single numbers

My data is like this
1
2
1-1
2-1
3-2

ASKER CERTIFIED SOLUTION

Brian Crowe

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zephyr_hex (Megan)

If you're using SQL 2016, you can use the built-in STRING_SPLIT function.

SOLUTION

zephyr_hex (Megan)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Pawan Kumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zephyr_hex (Megan)

@Pawan - Congrats to you for stepping up the level of your posts. You have improved the quality of your posts tremendously over the past few months.

Pawan Kumar

@ zephyr_hex - Thank you very much sir for the appreciation !!

Regards,
Pawan

Jim Horn

Another way is to use FOR XML PATH as demonstrated in this article - T-SQL: Normalized data to a single comma delineated string and back. Guessing the above experts comments will work for you as long as there are not any additional requirements not spelled out here.

>@Pawan - Congrats to you for stepping up the level of your posts. You have improved the quality of your posts tremendously over the past few months.
Agreed. You've gone from posting links to rock-star custom T-SQL, which really nails questions..

Hopefully this statement doesn't jinx things, but EE has annual awards that come out and with your point totals lately you're likely in the running for Rookie of the Year.

Pawan Kumar

@Jim Sir-
Thank you very much sir for the appreciation !!

Regards,
Pawan