Native ODBC on PRogress Data Base

[SSchmidt01]

Hi. Hoping I can get a bit of help. I have a Progress Database being accessed through Native ODBC into a SQL Server 2008 database. I need to test if a column exists opn the progress side . If it does not exists I need to use a CASE statement i.e
SELECT column a, column b, if column(abc) exists then column c else 'AUS', column d from xyx.
Can this be done and what command can I use.
Any help is appreciated.
Regards

Shane

 

[SkipVought]

hi,

being accessed through Native ODBC into a SQL Server 2008 database. I need to test if a column exists opn the progress side

I deduce that you have a non-normalized table, where columns are added as data elements, like a new date column for a new week, month, year etc. A HUGELY bad database design, and hence your dilema. Seems to me that you might want to post in forum183.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]