You can try the below however, this might take a long time depending on the number of records in the table.
USE YOUR_DATABASE_NAME
GO
DECLARE @MY_COL VARCHAR(50)
DECLARE @QRY VARCHAR (255)
declare kursor cursor for
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YOUR_TABLE_NAME'
OPEN kursor
FETCH NEXT FROM kursor INTO @MY_COL
WHILE @@FETCH_STATUS = 0
BEGIN
SET @QRY= 'SELECT '+@MY_COL+' FROM YOUR_TABLE_NAME WHERE '+@MY_COL+' =''ABC'''
PRINT @QRY
EXEC (@QRY)
FETCH NEXT FROM kursor INTO @MY_COL
END
CLOSE kursor
DEALLOCATE kursor