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

Can you help further

My dbf file consists of about 1000 records and 20 fields of which 10 could have accents - I dont know what the accents are I just need to remove all accents from all of the 10 fields for all of the 1000 records -

As an example one of the fields is called town - do you know a simple way of removing accents on that 1 field (if they exist, otherwise the field is unchanged) for all records in a scan of the file

Your help would be much appreciated as I have been struggling with this for several days and its now getting urgent - can you tell the me vfp code

Thanks

Colin