>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
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing