Hello, I need some info, that is it possible to find or make query ,that if we know the data stored in a table but don't know the field name in which the required data is stored.
Example Table having fields like columnA, columnB, columnC, columnD, ..........columnN and all have the same dataType. and you dont know in which field your data exists. suppose some data like e.g. "BackMan" exists in any Field of the table but we don't know in which Field this information is store. Is it possible that we can make a query to search the data Umair Tariq
RE: Hello,I need some info, that is it possible ...
Hi Umar
It is possible in the follwing way if u atleast know the column names where u r searching for the value
SELECT <Col1 ......Coln>
FROM <Tab1>
WHERE 'Backman' in (Col1 Col2 Col3...Coln);
It is even possible without even knowing the column names of the table atleast u know the table name. If u want to know the same feel free to email me back on gunasagarchalla@yahoo.com or for any other clarifications.
