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.
"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
>