>>>Hi All,
>>>
>>>Is there a function that will convert "É, Ê or È" into "E"? Since most of our employees are French. They have lots of accents in their names. In our main program that handles them this is allowed. But we need to export all the names into a SDF format. And import into a program that can't handle accents.
>>>
>>
>>You can use CHRTRAN() function
? CHRTRAN(lcStr, "ÉÊÈ", "EEE")
>
>Hi Sergey,
>
>This is what I've been doing:
>STRTRAN(STRTRAN(STRTRAN(STRTRAN(UPPER(PADR(ALLT(SUBSTR(export_cursor.last_name, 1, 22)) + "," + ALLT(export_cursor.first_name), 24, " ")), "É", "E"), "Ë", "E"), "È", "E"), "Ç", "C")
>
>But this still only covers what I've seen in the database. I'd like to do something that would cover all accents. There are lots more that I didn't cover. But as yet they haven't been used.
>
Hi Mike,
Take a look at SYS(15) function.
--sb--