Hi,
I do not understand the actual scenario what u are looking for,But you could try something like this..Hope this helps you :)
IF EXISTS(SELECT Name FROM SysObjects WHERE Name = 'ABCD')
BEGIN
DROP TABLE ABCD
END
GO
create TABLE ABCD
(
C1 varchar(25),
C2 Varchar(25),
C3 Varchar(25),
C4 Varchar(25)
)
GO
INSERT INTO ABCD(C1, C2 , C3 , C4)
VALUES('A','B','C', 'D')
GO
INSERT INTO ABCD(C1, C2 , C3 , C4)
VALUES('B','C','D', 'A')
GO
INSERT INTO ABCD(C1, C2 , C3 , C4)
VALUES('C','B','A', 'D')
GO
INSERT INTO ABCD(C1, C2 , C3 , C4)
VALUES('B','A','C', 'D')
GO
INSERT INTO ABCD(C1, C2 , C3 , C4)
VALUES('X','Y','Z', 'Z')
GO
SELECT * FROM ABCD WHERE C1 = 'A'
UNION ALL
SELECT * FROM ABCD WHERE C2 = 'A'
UNION ALL
SELECT * FROM ABCD WHERE C3 = 'A'
UNION ALL
SELECT * FROM ABCD WHERE C4 = 'A'