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