Database

<br />
DECLARE @Array varchar(50)<br />
DECLARE @iStart int<br />
DECLARE @iEleFound int<br />
DECLARE @iMaxEleLen int<br />
DECLARE @iNextDelimIndex int<br />
DECLARE @iEleLen int<br />
<br />
SET @Array = '1,2,3,4,5,6,7,8,9,65,66,67,100,101,102,654321'<br />
SET @iStart = 0<br />
SET @iEleFound = 0<br />
SET @iMaxEleLen = 5<br />
SET @iNextDelimIndex=0<br />
SET @iEleLen =0<br />
<br />
print '---------'<br />
print 'LENGTH of string: ' + CAST(LEN(@Array) AS VARCHAR)<br />
while CHARINDEX ( ',' , @Array,@iStart  ) > 0    -- for each element in the array<br />
 begin<br />
      SET @iEleLen =1 --default	     <br />
      --if not ',' or ''<br />
      if (CAST(SUBSTRING(@Array, @iStart + 1, 1) AS char(1)) <> ',') and not(len (SUBSTRING (@Array, @iStart + 1, 1)) = 0)<br />
        begin--element found at this index<br />
<br />
 	  SET @iNextDelimIndex = CHARINDEX ( ',' , @Array,@iStart+1)	<br />
	  if(@iNextDelimIndex=0)<br />
		begin<br />
			SET @iNextDelimIndex =  CAST (LEN(@Array) AS VARCHAR)+1<br />
			print 'latest element is next:'<br />
		end <br />
          SET @iEleLen = @iNextDelimIndex - @iStart<br />
	  --DB function would occur here<br />
          print 'NEXT DELIM LOCATION-->' +  CAST(@iNextDelimIndex AS VARCHAR(10))<br />
	  print 'VALUE FOUND-->' +  RTRIM( CAST(SUBSTRING(@Array, @iStart + 1, @iNextDelimIndex - @iStart-1) AS char(10))  ) + '<--'<br />
<br />
<br />
          SET @iEleFound = @iEleFound + 1 <br />
<br />
<br />
        end<br />
<br />
       else --no element found at this index<br />
        begin<br />
         print 'do nothing'<br />
        end<br />
<br />
       SET @iStart = @iStart + @iEleLen<br />
<br />
     end --if (CAST(SUBSTRING(@Array, @iStart + 1, 1) AS char(1)) <> ',') and not(len (SUBSTRING (@Array, @iStart + 1, 1)) = 0)<br />
 <br />
print '------  ELEMENTS FOUND: '  + CAST(@iEleFound AS CHAR(2)) +   '  ---------'<br />