At 10:09 AM 27-09-01 +0200, you wrote:

>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.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________