I think I can modify the LetterSearch plugin to do a DISTINCT search but I'm not sure how to modify the following line -

my $sth = $table->select ( GT::SQL::Condition->new ($column, 'LIKE', "$letter%") );

How can I change the red part to do a DISTINCT search for $letter in $column.

I've tried all sorts of things like ('DISTINCT', $column, "$letter%"), etc.. but nothing seems to work.

Any ideas?

Thanks

Simon.