Alan McDonald wrote:

>> Hi. We have a table with applicants and use the 'select distinct
>> (surname) from applicant' to populate a drop-down.
>>
>> The resulting list includes applicant with a surname "Wilson " but
>> not "Wilson".

As others have said, "Wilson" = "Wilson " under SQL rules.

>>
>
> Is the (surname) field a varchar? or char? It might be char in your case and
> maybe it should be varchar.

The rules are the same for char and varchar.

Good luck,

Ann