Is it possible to retrieve the entries in an index?

In the case of a text index, this would be all the strings that are in the index - although I am interesetd in text and varchar.

Retrieving the entries in a query statement would be ideal, but if it is available in another way thats ok too.

Bryn

>Is it possible to retrieve the entries in an index?
>
>In the case of a text index, this would be all the strings that are in the index - although I am interesetd in text and varchar.
>
>Retrieving the entries in a query statement would be ideal, but if it is available in another way thats ok too.

I vaguely remember asking Tim something along these lines for full text indices ages ago and the answer was no. Things may have changed since then but if so its escaped my notice.

For normal, non full text indices, its easy unless you want the actual strings held in the tree - just SELECT DISTINCT field FROM table

Roy Lambert [Team Elevate]