My statement for testing yours was (SELECT STUFF(IName,LEN(IName-3),3,'GIF') from dbo.MImage2)

this gives an error

(Server: Msg 245, Level 16, State 1, Line 1

Syntax error converting the varchar value '07072704.JPG' to...

If you wish to remove the last 3 characters you can do this in the select statement without modifing the table contents (select reverse(stuff(reverse(field_name),1,3,'fig'))Field_Name

I do this to rename...