search and replace

I have a field in one of my tables that has a path to a file listed. I need to move those files and now have to update
allthose paths. Is there a simply search and replace type option in sql? or do I need to do an update using the entire
newpath name?<br /> If so, I think the easier solution will be to dump the table, use a macro to update it and then
restore.<br/> Jodi<br /><div class="moz-signature">-- <br /></div><div class="Section1"><p class="MsoNormal"><i><span
style="font-size:9pt; font-family: Arial;">_______________________________<br /></span></i><i><span style="font-size:
10pt;">JodiL Kanter<br /> BioInformatics Database Administrator<br /> University of Virginia<br /> (434) 924-2846<br
/><ahref="mailto:jkanter@virginia.edu">jkanter@virginia.edu</a></span></i><span style="font-size: 11pt; font-family:
Arial;"><brstyle="" /><br style="" /></span><p class="MsoNormal"><span style="font-size: 11pt; font-family:
Arial;"> </span><pclass="MsoNormal"><i><span style="font-size: 9pt; font-family: Arial;"> </span></i><p
class="MsoNormal"><i><spanstyle="font-size: 9pt; font-family: Arial;"> </span></i></div>