SUBSTRING Functions

Transact-SQL
7

hi

hope this helps

solved = yes 

why am i doing this ? = tally table approach 
                      = among other reasons = one being neuro science

declare @t varchar(300) = 'Inv 3225366, BUK-100694, London Distribution Solutions B, PICKING 37,531 @£0.20'

;WITH Tally AS ( SELECT TOP (LEN(@t))  ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS n FROM sys.objects)
SELECT 
   SUBSTRING(@t, n, CHARINDEX(',', @t + ',', n) - n) AS Value
FROM Tally
  WHERE SUBSTRING(',' + @t, n, 1) = ','
   AND 
 SUBSTRING(@t, n, CHARINDEX(',', @t + ',', n) - n) like '%BUK%';

image