Helen,

> > > 2. I set your Keylinks to ID. (Notice that I had a little trouble with this because you made this a char(12) so your unique id values get stored as "FIRST ", "SECOND " and "THIRD " and a query 'where "ID" = 'FIRST' will not find the row...
> >
> >According to the SQL standard and how IB implements it, it surely
> >should.
>
> Nando,
> Test it for yourself. Char fields get right-padded with ascii 32 at creation time.

Sure. So do string constants when a comparison must be made against a
char field, so that

where ID = 'FIRST'

is actually evaluated as

where ID = 'FIRST '

assuming that ID is a CHAR(12) field.
I hope I have made it a little clearer now.
Test it for yourself. ;-)
Ciao
--
____
_/\/ando