I have a table that has a list of file names as one of its columns.
All of the file names are .jpg files, and we just converted to .png
because all the cool kids are using .png files for web design now (or so
I'm told). I am trying to figure out how to update the database so the
file name in the table will now have a .png extension. Only the
extension changed. If the old name was MyPic.jpg, the new name is
MyPic.png.
I think that I should use the UPDATE command with an expression, but
I'm not sure what expression to use. In psudocode:
UPDATE mytable SET filename = (SMOVE(<current value in
filename>,1,SLEN(<current value in filename>) - 3,'',1) + '.png') WHERE
filename IS NOT NULL
Thanks,
Jason
--
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
