IF OBJECT_ID('tempdb..#strings') IS NOT NULL DROP TABLE #strings;CREATE TABLE #strings (string_id int primary key, string varchar(20));INSERT INTO #strings SELECT 1, 'KET+N.207-13-F4001' UNION ALL SELECT 2,'KET+DG014-13-F4011' UNION ALL SELECT 3,'KET+RE002-36-MV009';SELECT string_id, itemFROM #strings sCROSS APPLY dbo.PatternSplitCM(string,'%-%') WHERE Matched=0GO--Lets say we want to split by '-' & '+'SELECT string_id, itemFROM #stringsCROSS APPLY dbo.PatternSplitCM(string,'%[+-]%') WHERE Matched=0--Lets say we want to split by '-' & '+' & '.'SELECT string_id, itemFROM #stringsCROSS APPLY dbo.PatternSplitCM(string,'%[+-.]%') WHERE Matched=0