Look at the STUFF() function.



>I need a function that works as an inverted Extract... It should return everything before a specified delimeter and everything after a specified delimiter with the option to insert something in the middle.
>
>In a working example for what I need it for is the following string:
>
>driver={SQL Server};server=(local);database=master;uid=sa;pwd=;
>
>In my program the database= could be many different values (here its master but I don't know at runtime). So I want to be able to insert something between database= and ; and remove whatever is there.
>
>Is there any build in function if VFP for doing that?