I am writing a routine which goes out and queries information from remote sites. 90% of the time, all the sites have the exact same database structure, but that other 10% for whatever reason, haven't received the latest update.

I need to query a couple fields from a table, and I need to structure my statement so that a field doesn't exists, that I return a blank value for that rather than having the whole query fail. Is there a way to structure that in a query of stored procedure?

Thanks

Kirk