Hi Mohammed,

check the SQL UPDATE command in help!

UPDATE NEWAMAR66 SET CHAR18='3' WHERE CHAR8="ÌäæÈ ÚãÇä                                         "
UPDATE NEWAMAR66 SET CHAR18='8' WHERE CHAR8="ãÍÇÝÙÉ ÇÑÈÏ                                       "
UPDATE NEWAMAR66 SET CHAR18='2' WHERE CHAR8="ÛÑÈ ÚãÇä                                          "

Over all, I suggest you read all the stuff about SQL, in SQL you can often do very much in just one command.

>hi all,
>i write this small code,it works,
>but i search for somthing more logic.
>
>

>USE NEWAMAR66
>SET FILTER TO  CHAR8="ÌäæÈ ÚãÇä                                         "
>REPLACE ALL  CHAR18 WITH "3"
>
>SET FILTER TO  CHAR8="ãÍÇÝÙÉ ÇÑÈÏ                                       "
>REPLACE ALL  CHAR18 WITH "8"
>
>SET FILTER TO  CHAR8="ÛÑÈ ÚãÇä                                          "
>REPLACE ALL  CHAR18 WITH "2"
>.
>.
>.
>
>

>
>thanks
>m.qasem