hello Helen,

> You would have to uppercase the derived value in your retrieval expression

as usual, thanks for your exhausting explanation about derived fields. I was
wondering if eliminating the derived field could do the trick:

SQL:
SELECT A.ID, A.NAME, P.SHORT_NAME
FROM ANAG A
JOIN PROV P ON P.ID = A.PROVINCE

But i suspect that this statement will be not updateable...

Cheers
Salvatore