I have successfully done a conversion of the characterset (via the alter database statement).

We are now looking for values that were already stored in the old format (eg the accent was stored like a block). We are considering using the chr() function to seach the field for any characters higher that chr(127) since we converted from us7ascii to WE8MSWIN1252.

Any help into the sql statement or alternative methods would be greatly appreciated.

Thanks in advance