SET @Str = 'James Murphy;#278;#Leslie Owens;#275;#Rita Sallam;#279;#Stephen Powers;#277;#Susan Feldman;#68'

--CHAR(59) is a ; CHAR(35) is #

SET @Str = REPLACE(@Str,CHAR(59) + CHAR(35),',')
WHILE PATINDEX('%[0-9]%',@Str) > 0
BEGIN
   SET @Len = LEN(@Str)
   SET @T = SUBSTRING(@Str,PATINDEX ( '%[0-9]%' , @Str),PATINDEX ( '%[0-9]%' , @Str)+1)
   IF @T = 0
      BREAK
   ELSE
      SET @Str = REPLACE(@Str,@T,'')
      CONTINUE
END
SET @Str = REPLACE(@Str,',,',',')   
SELECT @Str AS 'Final'