|Subject||RE: [firebird-support] FB 2.1 Issue with select distinct|
> Hi. We have a table with applicants and use the 'select distinctIs the (surname) field a varchar? or char? It might be char in your case and
> (surname) from applicant' to populate a drop-down.
> The resulting list includes applicant with a surname "Wilson " but
> not "Wilson".
> Any ideas about why this could be? We are using Firebird 2.1 on Windows
> 2003 Server.
> Regards, Pieter
maybe it should be varchar.
How are the values inserted or updated? via your own interface or via an
external datapump of some kind?