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
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.