I have a requirement where I need to get a list of all possible field values for a specific field. This would be used to populate a drop-down list in a 3rd party app.

For example given the field Title I would like to be able to run a query similar to the following SQL query.

SELECT DISTINCT Title FROM Lead

or

SELECT DISTINCT LeadStatus FROM Lead

Is this possible?

Thanks

Dave