>Hi,
>
>I am looking for an analog of xBase STUFF function, which searches and replaces characters within a character string. Unfortunately, I couldn't find any ready to use function in VB(MS Access).
>Do I miss something?
>
>Thanks in advance.
Try to use MID statement(not function).It replaces a specified number of characters in a Variant (String) variable with characters from another string.