Select
[CorpGroupName],
[Div],
[Corps],
left([Corps], charindex(',', [Corps])-1) as City,
SUBSTRING([Corps], CHARINDEX(',', [Corps]) + 1, LEN([Corps])) as [State]
From [dbo].[Corp]
Split One Column to 2 column - SQL Query
Split One Column to 2 column from comma separator using SUBSTRING, LEFT, LEN Functions
Select
[CorpGroupName],
[Div],
[Corps],
left([Corps], charindex(',', [Corps])-1) as City,
SUBSTRING([Corps], CHARINDEX(',', [Corps]) + 1, LEN([Corps])) as [State]
From [dbo].[Corp]
Select
[CorpGroupName],
[Div],
[Corps],
left([Corps], charindex(',', [Corps])-1) as City,
SUBSTRING([Corps], CHARINDEX(',', [Corps]) + 1, LEN([Corps])) as [State]
From [dbo].[Corp]
