Here&#039s a stumper for you, I hope.<BR><BR>I have a column, image, which contains a relative url to a -- you guessed it -- image file. I am also importing data from a different directory structure, and although the filenames are the same, the paths are not.<BR><BR>Is there any way with one SQL instruction I can go in and replace "/news/" with "images/" and leave the filename the same?<BR><BR>Thanks a bunch.<BR><BR>Ben