Hello again Richard,

I re-examined the logic of what you submitted and realised the last line is the key.

By changing

and constits.constit <> 'STF'

to

and constits.constit = 'STF'

I get the...

Oops my apologies Richard,

Too much assaulting my brain when I replied.

I've just retried your code as is using <> 'PC' (I used <> 'STF' when I got no results) and...

Thanks for the sound advice Wayne,

I'm only using it to extract data for something else outside of the database. It will never be used to inject data back in and...

Sorry Andrew,

that query returned no results at all.

One acperkins submitted the following which does work:

SELECT c.ID, c.Surname, c.GivenName

FROM Community c

...