InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 17:09:53 GMT20http://www.sqlservercentral.com/Forums/Topic1392307-392-1.aspxYou can try the below however, this might take a long time depending on the number of records in the table.USE YOUR_DATABASE_NAMEGODECLARE @MY_COL VARCHAR(50)DECLARE @QRY VARCHAR (255)declare kursor cursor forSELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'YOUR_TABLE_NAME'OPEN kursorFETCH 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 @QRYEXEC (@QRY) FETCH NEXT FROM kursor INTO @MY_COL END CLOSE kursor DEALLOCATE kursor Tue, 04 Dec 2012 03:09:30 GMTarunyadav007http://www.sqlservercentral.com/Forums/Topic1392307-392-1.aspxHi,I have table which have number of columns one of these columns contains value say 'ABC' I have to find the column name which contain ABCTue, 04 Dec 2012 02:48:15 GMTkapil_kk