I think I’ve solved this myself by just using:

select * from INFORMATION_SCHEMA.columns

I can then filter on the Column Default to show the records that aren’t NULL, and then subsequently filter...

Hi Kingston,

Thank you very much, that's exactly what I was after.

Such a simple way of doing it, but without your help I don't think I could have managed to get...

Hi Koen,

My apologies, I will need to read your link regarding posts as I am a bit of a novice.

In regards to my last post that was just a snippet...

Hi SSChampion,

Thanks for the response, much appreciated.

The union does work however it returns 2 records where I only want one. I only want to see the sum of the...

Thanks veryu much Sean, have a great day.:-)

Thanks Anthony,

I have some fairly complex statements and this works a treat.

Cheers, Marisa

Thanks Mike, you are a star!

😀

Thanks Lowell,

The coalesce statement works and is nice and simple.

It looks for a value in the columns I specify (in order) and can return a default (ie: 42 in your...