On 2008-03-27, No_One <no_one@no_where.com> wrote:
>
> try you query as SELECT DISTINCT vendname FROM $table where
> length(vendname) > 0
>
> ken

Forget it, I misread your post....will not work unless you trim the field

my mistake

ken