I have a table with a field containing image file names. Some end in .jpg and some in .gif. Is there a SQL-only way that I can change all of the extensions to .gif, or will I have to write a program to loop through and handle each one?
I guess basically what I need is to search and replace all instances of .jpg with .gif. Any ideas?