Hi Lynn,

What if the source data contained the same pattern that is repeated many times? Example:

SELECT 1,'001N data 002N003N004N','data' UNION

SELECT 2,'005N005Ndata007N','data' UNION

SELECT 3,'data 008N009N010N','data ' UNION

SELECT 4,'data011Nsome012Nmore013Ndata014N','datasomemoredata' UNION

SELECT 5,'data015N some...