Scott, > "create unique index" > > "select distinct"
I believe that one does this by adding to the word root dictionary and rebuilding the index. The problem is that then anything indexed as "select distinct" shows up under searches for "select distinct" but not for "distinct". Try searching on SELECT & DISTINCT -- -Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly