DECLARE@SRESULT AS VARCHAR(200)
BEGIN TRANSACTION
DECLARE @SPOT AS VARCHAR(10)
DECLARE @PROJECT AS VARCHAR(30) IF(RIGHT(@PROJECTLIST,LEN(@PROJECTLIST)+1 -LEN(@PROJECTLIST))) <> ','
SET @PROJECTLIST = @PROJECTLIST+','
SET @SRESULT=''
WHILE @PROJECTLIST <> ''
BEGIN
SET @SPOT=CHARINDEX(',',@PROJECTLIST)
IF(@SPOT > 1) BEGIN SET
@SPOT =CHARINDEX(',',@PROJECTLIST)
SET @PROJECT =LEFT(@PROJECTLIST,@SPOT-1)
SET @PROJECTLIST=RIGHT(@PROJECTLIST,
LEN(@PROJECTLIST)-@SPOT)
PRINT @PROJECTLIST
PRINT @PROJECT PRINT
