|Subject||Re: [firebird-support] FB 2.1 Issue with select distinct|
|Author||Ann W. Harrison|
Alan McDonald wrote:
>> Hi. We have a table with applicants and use the 'select distinctAs others have said, "Wilson" = "Wilson " under SQL rules.
>> (surname) from applicant' to populate a drop-down.
>> The resulting list includes applicant with a surname "Wilson " but
>> not "Wilson".
>>The rules are the same for char and varchar.
> Is the (surname) field a varchar? or char? It might be char in your case and
> maybe it should be varchar.