>Here is an example of a select which converts into some of that:
>
>

>SELECT Member.Numero
> FROM Member
> WHERE Member.NoCountry=1 AND Member.NoProvince=2 AND
>  CHRTRAN(Member.City,"ÀÁÂÃÄÅÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖÙÚÛÜÝàáâãäåçèéêëìíîïðñòóôõöùúûüýÿ","AAAAAACEEEEIIIIDNOOOOOUUUUYaaaaaaceeeeiiiidnooooouuuuyy")
>  ORDER BY Member.LastName,Member.FirstName
>

sorry I dont quite understand

I have a field Paris La D‚fense It should be Paris La Defense - I think th seond letter has an acute accent or am I mistaken?

Colin