Display transform horizontal to Vertical of the strings

Asked Aug 31 '18 at 09:05

Active Aug 31 '18 at 12:31

Viewed 50 times

Declare @String Varchar(80) Set @string ='chennai,mumbai,Bangalore,Hyderabad,pune'

I want to output like this

chennai
mumbai 
Bangalore
Hyderabad
Pune

edited Aug 31 '18 at 12:31

asked Aug 31 '18 at 09:05

Krishna M

2

https://stackoverflow.com/questions/20698318/how-to-split-a-string-into-variables-in-sql – YLG Aug 31 '18 at 09:08
This may help you – YLG Aug 31 '18 at 09:08
SQL Server has no data type called "array", so your question is unclear. – Gordon Linoff Aug 31 '18 at 10:50

0 Answers0