rafidheenm (12/22/2009)
Hi ezhil,please check this article ..
This article has two types of split.
1. XML split
2. SQL Function (Basic SQL string split for SQL 2000 or later)
http://www.sqlservercentral.com/articles/XML/66932/
With regards,
Rafidheen.M
Just saw this so sorry for the really late post on it. Splitting strings using XML is comparatively dog slow and shouldn't be used. Instead, use either a Tally/Numbers table splitter or a cteTally splitter.
--Jeff Moden
Change is inevitable... Change for the better is not.