Help me with SQL

[raamay]

i have a table with coulmns as C1, C2, C3, C4 which contains datas like A, B, C & D. Now how should i select records where the data is A in any one of this column. I mean i want to select records which has A as the data in any one of this columns.

Please advise me!

[csenasa]

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'