Hi Mike,

Are you insinuating that I did not read the help file? :-) I did, under SET COLLATE but did not see anything. It actually dawned on me 1/2 an hour after posting this to try that (isn't that usually the case - as an old guy used to say "thoughts disentangle themselves when they flow over the lips or through the finger tips".

Regarding the UPPER() on the vars, I would have thought that this only fired once at the start of the command firing - not on every row. Just trying to avoid a couple extra lines.

As you can probably tell, this discussion was also picked up over on Foxite. I had hoped that Steve Black might jump in as he used to be at least the guru on accented characters etc. I used his INTL app years ago to INTLize a hockey app. Everything seemed to work there - maybe I had better go over and open up that 2.6 code...

Albert

>You will have to SET COLLATE TO GENERAL before doing the SELECT. Says so right in the help. :)
>
>While you're doing that you might also upper your memory variable once in advance of the query rather than per row.
>
>SET COLLATE TO GENERAL
>lcLastName = UPPER(m.lcLastName)
>lcFirstName = UPPER(m.lcFirstName)
>
>SELECT Lastname, Firstname ;
> FROM Lawyers ;
> WHERE UPPER(lastname) == m.lcLastname AND ;
> UPPER(Firstname) == m.lcFirstname ;
> INTO ARRAY laNames
>
>HTH