replace a part of a string in a Table

hey,

I have a lage table with 1000's of records..
there is a column with the path to some files.

example: "R:\mutaties\test.pdf"

i need to change that path to "L:\archive\mutaties\test.pdf"

i will replace "R:\" with "L:\archive\" in all the records.. what;'s the simpelst way tot do this?

can i do a replace with SQL-queries? , or do i need to write a code/script for this?

grtz,
Blueupdate LargeTable
set Column = 'L:\archive' + substring(Column, 3, length(Column) - 3)
where Column like 'R:\%'|||Thanx Pierre ;)

I will try it :D