with cte as ( select ID from TableName Group By ID Having Count(SUBSTRING(ColumnName,StartIndex,EndIndex))>1 ) Select * from TableName s,cte c where s.ID=c.ID and s.ID='YourID'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)