Resp_Code      |   Conflicts
________A______|_____B,D,C_____
________B______|______D,A______
________C______|______A__________
________D______|______A,B_________ 

Resp_Code | Conflicts
________B______|______D______
________C______|______A__________
________D______|______B_________

IF EXISTS (
	SELECT * from dbo.sysobjects
	WHERE 
		id = object_id(N'[dbo].[fn_Split]')
		AND xtype IN (N'FN', N'IF', N'TF')
	)
	DROP FUNCTION [dbo].[fn_Split]
GO


CREATE FUNCTION fn_Split (@text VARCHAR(MAX), @delimiter VARCHAR(20) = ' ')

	RETURNS @Strings TABLE (
		position INT IDENTITY PRIMARY KEY
		, value VARCHAR(8000)
		)

AS BEGIN
	DECLARE @index int
	SET @index = -1

	WHILE (LEN(@text) > 0) BEGIN
		-- Find the first delimiter
		SET @index = CHARINDEX(@delimiter , @text)

		-- No delimiter left?
		-- Insert the remaining @text and break the loop
		IF (@index = 0) AND (LEN(@text) > 0) BEGIN  
			INSERT INTO @Strings VALUES (@text)
			BREAK 
		END 

		-- Found a delimiter
		-- Insert left of the delimiter and truncate the @text
		IF (@index > 1) BEGIN
			INSERT INTO @Strings VALUES (LEFT(@text, @index - 1))
			SET @text = RIGHT(@text, (LEN(@text) - @index))
		END
		-- Delimiter is 1st position = no @text to insert
		ELSE SET @text = RIGHT(@text, (LEN(@text) - @index))
	END
	RETURN
END
GO


DECLARE @targetResp CHAR(1) SET @targetResp = 'A'
DECLARE @conflicts VARCHAR(MAX)

DECLARE @foo TABLE (
	[Resp_Code] CHAR(1) PRIMARY KEY
	, [conflicts] VARCHAR(MAX)
	)

INSERT @foo ([resp_code], [conflicts])
      SELECT 'A', 'B,D,C'
UNION SELECT 'B', 'D,A'
UNION SELECT 'C', 'A'
UNION SELECT 'D', 'A,B'

SELECT * FROM @foo

-- Start the changes
SELECT @conflicts = [conflicts] FROM @foo WHERE [resp_code] = @targetResp
SELECT @conflicts

UPDATE f SET [conflicts] = REPLACE(REPLACE(REPLACE([conflicts], ',' + @targetResp, ''), @targetResp + ',', ''), @targetResp, '')
FROM
	@foo f
	JOIN (
		SELECT
			[value] AS [resp_code]
			, [position] AS [pos]
		 FROM fn_Split(@conflicts, ',' )
		)
		u ON u.[resp_code] = f.[resp_code]

DELETE @foo WHERE [resp_code] = @targetResp

SELECT * FROM @foo

quote:

---

Originally posted by osirisa

WOW, CHARLIE, I AM REALLY IMPRESSED, YOU ARE AWESON IN T-SQL.

---