modifying multi image names

Perfect. That's what I was after.

Thanks a million

Bill


"DataPacks.com" <webforumsuser@macromedia.com> wrote in message
news:e4e0im$fkg$1@forums.macromedia.com...
> Hi All
>
> I'm wondering if anyone can help with this. I have a field in my database
> that holds about 2000 image name. Each image ends with the characters
> 3.jpg
> E.G. MyImage3.JPG
>
> what I am trying to do is create an Update query to changes each of the
> image names from MyImage3.jpg to MyImage2.jpg
>
> I've been trying with an output query to an update query but I can't seem
> to get the part of trimming the 3.jpg off and adding the 2.jpg.
>
> Any ideas would be greatly appreciated.
>
> Bill
>

This will depend upon which db your using.

But, something like the following will be close in ms access

Update myTable
Set columnName = Left(columnName, InStr(columnName, '3.jpg', 1)) + '2.jpg'