Paul,

Thanks for your reply but it didn't make any difference.

I just can't get it to work with the GT::SQL::Condition->new.

I can get it to work using -

my $sth = $table->select ('DISTINCT $column','LIKE',"$letter%");

but not with -

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

I guess I'll just go with the one that works but I would still like to know why the other doesn't work if anyone has any ideas.

Thanks

Simon.