So, this means that a negative number is not considered to be a "number", but a "formula".

In essence: -100.0 does NOT mean to subtract 100, but to represent a negative...

• This reply was modified 4 years, 5 months ago by  HarryKroek.
• This reply was modified 4 years, 5 months ago by  HarryKroek.

I think i would use the Case-function to determine a 'priority' for each row,

en then select the record with the highest priority.

Like this:

First, the determination of priority:

SELECT *,

...