I see, that is a much better solution. Thanks so much.

So thanks for the sample. It was very close, I tweaked it to this:

(COALESCE(Database_Status,Instance_Status) = N'deployed' or is null)

And it's now displaying the expected results. Thanks so much.

So, forgive me I'm a new to some of these statements. It appears to me the COALESCE statement is looking at both. I only care about the 'Instance_Status'...

So I'm selecting a bunch of data. If the value in 'Database_Status' is null the filter needs to shift to the 'Instance_Status' column. Which is why my thinking...

Thanks,

That still didn't work, it still is numeric.