getting a column name based on a value
Posted: Mon Sep 17, 2007 1:15 am
Hi,
I am trying to obtain the column name of a data item in the database.
For example if I have a table A with a column reptiles. In this column reptiles I have an entry snake.
Now if I know about the value snake , how can I obtain its column name(which in the example is reptiles) using an sql statement.
I appreciate your help.
Thanks
-Nayeem
I am trying to obtain the column name of a data item in the database.
For example if I have a table A with a column reptiles. In this column reptiles I have an entry snake.
Now if I know about the value snake , how can I obtain its column name(which in the example is reptiles) using an sql statement.
I appreciate your help.
Thanks
-Nayeem