CREATE TABLE Sometable (keycol CHAR(1) PRIMARY KEY, colx INTEGER NOT NULL)

INSERT INTO Sometable VALUES ('a',1)
INSERT INTO Sometable VALUES ('x',9)

UPDATE Sometable
SET colx =
CASE keycol
WHEN 'a' THEN (SELECT colx FROM Sometable WHERE keycol = 'x')
WHEN 'x' THEN (SELECT colx FROM Sometable WHERE keycol = 'a')
END

--
David Portas
------------
Please reply only to the newsgroup
--