I know. Not the way I would have designed it but I inherited this and am stuck using it.

SELECT

[transaction_detail_id]

,[transaction_code]

,[transaction_short_desc]

,[transaction_desc]

[highlight=#ffff11] ...

I have a table that has 15 varchar columns they all contain data like "ABC" or are null I am trying to find if any of these column have data...