SQL Server comma separated

Question

I have a question about splitting column values ​​in T-SQL. I have

Address_col Nevada,USA Tokyo,Japan Hanoi,Vietnam 

I want to split values ​​by comma

 Address_col Country Navada USA Tokyo Japan Hanoi Vietnam 

How can i do this?

Answer 1

 declare @T table (Address_col varchar(20)) insert into @T values ('Nevada,USA'), ('Tokyo,Japan'), ('Hanoi,Vietnam') select left(Address_col, charindex(',', Address_col)-1) as Address_col, stuff(Address_col, 1, charindex(',', Address_col), '') as Country from @T 

Update:
A split line with three parts might look like this: declare a table @T (Address_col varchar (20))

 insert into @T values ('Nevada,USA,World'), ('Tokyo,Japan,World'), ('Hanoi,Vietnam,World') select parsename(C, 3), parsename(C, 2), parsename(C, 1) from @T cross apply (select replace(Address_col, ',', '.')) as T(C) 

Answer 2

If you have only two parts, this is the simplest thing I can think of.

select SUBSTRING (Address_col, 1, CHARINDEX (',', Address_col) -1) as Address_col, SUBSTRING (Address_col, CHARINDEX (',', Address_col) + 1, LEN (Address_col)) as Country