>If there is a way to merge three field in a new field without passing by the replace command. the field are of the same datatype.
>thank you
Instead of REPLACE you can use the UPDATE - SQL command.
update MyTable;
set Combined = alltrim(Field1) + space(1) + alltrim(Field2) + space(1);
+ alltrim(Field3)
This will replace ALL records. You can also put a condition to the UPDATE - SQL command.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)