Subject FB 2.1 Issue with select distinct
Author Estie
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".

Any ideas about why this could be? We are using Firebird 2.1 on Windows
2003 Server.
Regards, Pieter