Thanks very much Niall, the SELECT DISTINCT column FROM table is doing
exactly what I was looking for.
The ORDER BY clause gives the whole list and that's not what I wanted.
This email and any attachments to it may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any views or
opinions expressed are solely those of the author and do not necessarily
represent those of the sender of this email.
If you are not the intended recipient of this email, you must neither take
any action based upon its contents, nor copy or show it to anyone.