SQL split funtion 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 Share April 21, 2011 by Prakash SQL Server Uncategorized