how can i rename a picture name stored in a table
Posted on 2013-06-28
I have a database with a table named myimages, this contains a field named imagepath which is an ntext datatype.
Imagepath contains the names of several thousand images a lot of which end in .tif
I want to rename the .tif files to be .png
How can I do this?
when I tried
where imagepath like '%.tif'
I received an error message.
Can anyone help me with the syntax to update the table?