SQL——CHARINDEX,找到字符(char)的位置(index)
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