Is it possible using `SQL` in an `SQLite` table to replace part of a string?

For example, I have a table where one of the fields holds the path to a file.
Is it possible to replace parts of the string so that, e.g.

```
c:\afolder\afilename.bmp

```

becomes

```
c:\anewfolder\afilename.bmp

```

?