DECLARE @ItemCode VARCHAR(50)
SET @ItemCode = '1,2,34,56,78,9,0'
WHILE (CHARINDEX(',', @ItemCode) <> 0)
BEGIN
    PRINT (SUBSTRING(@ItemCode, 1, CHARINDEX(',', @ItemCode) - 1))
    SET @ItemCode = STUFF(@ItemCode, 1, CHARINDEX(',', @ItemCode), '')
    PRINT @ItemCode
END
PRINT @ItemCode