[sqlite] INDEX list

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. Regards, Rob -- This email and any attachments to it may be confidential and are intended solely for the use of the

[sqlite] Index list

I want to use the index of a specific column of a table as a pulldown list in my application. But I can't find any syntax how to select or view an index. Thanks Rob van der Sloot -- This email and any attachments to it may be confidential and are intended solely for the use of the individual