I'd like to know if it's possible to ave a query that looks for columns befor it actually selects? I might not be asking this correctly, so let me give an example.
Select (fname or first_name) as FirstN
Basically scan the dataset to see what the available columns are and then when I find a matching one, pull that data.
The data set is populated dynamically and may have fname or first_name or firstN. I'll know it'll have one of them. I just want to write 1 select to pull the data regardless of the col name. Thanks.
Select (fname or first_name) as FirstN
Basically scan the dataset to see what the available columns are and then when I find a matching one, pull that data.
The data set is populated dynamically and may have fname or first_name or firstN. I'll know it'll have one of them. I just want to write 1 select to pull the data regardless of the col name. Thanks.