how to get column name

[sukumaster]

Hello everybody,

i am sukumar n i m new to tis forum. I want to get column name in which desired value is present

for an instance if value 'PAL' is present in a column 'ITEM' , i should get ITEM as result.

regards,
suku

[ck9663]

Hello everybody,

i am sukumar n i m new to tis forum. I want to get column name in which desired value is present

for an instance if value 'PAL' is present in a column 'ITEM' , i should get ITEM as result.

regards,
suku

give the pseudocode here....or at least the logic of what you're trying to do

[sukumaster]

I have a table of columns c1,c2,c3 and one of the column has the value 'PAL'. I just want to get the name of the column which contanis the value 'PAL'

[hoomaniraji]

hi
suppose you have Table1(C1,C2,C3)
you have two solution :
1- For Static usage you can use Select Sql Statement with this format :
Select 'C1'
from Table1
where Table1.C1 = "PAL"
union
Select 'C2'
from Table1
where Table1.C2 = "PAL"
union
Select 'C3'
from Table1
where Table1.C3 = "PAL"
2-For dynamic usage for any table without knowing its column name you must use System Tables Or System Metadata Functions in your select statement.

if you need more about the second solution.reply this message so i will find the function for you.

[sukumaster]

Its Working Thx a ton

can u give me a solution for dynamic table name?