ex. 1. select top 10 * from dbo.split(‘Chennai,Bangalore,Mumbai’,’,’)

Link: http://blog.logiclabz.com/sql-server/split-function-in-sql-server-to-break-comma-separated-strings-into-table.aspx