This is what i'm using.   not sure if its the most effective way of working it but does the job.

SELECT DISTINCT QuoteID, 'Plus VAT' AS VAT

FROM         (SELECT DISTINCT QuoteID, Country

                      ...

Took a little bit of modification to get it working but it was pretty much there.  Never would have thought of that in a million years though so thanks very...