You could do something like this to parse the csv list and put it in a temp table so you can join on it later.CREATE TABLE #Tmp_ID( ID INT NOT NULL)WHILE @SYSID > ''BEGIN IF (SELECT PATINDEX('%,%',@SYSID)) > 0--check for a comma BEGIN --get the first part INSERT INTO #Tmp_FacID SELECT SUBSTRING(@SYSID,1,PATINDEX('%,%',@SYSID)-1) --reset the string SELECT @SYSID = SUBSTRING(@SYSID,PATINDEX('%,%',@SYSID)+1,LEN(@SYSID)) END --now insert final val ELSE BEGIN INSERT INTO #Tmp_FacID SELECT @SYSID --reset str Select @SYSID = '' ENDEND
HTH,Scooter McFly