Using InStr & Len

[homer661]

I want to take my picture fields in my database and change the extension of them. My picture field [IN_Pic] looks like this:

umpic26923.jpg

I wrote this statement:

"th_" & Left([IN_Pic],Len([IN_Pic])+InStr([IN_Pic],".&quot) & ".gif"

Now my picture looks like this:

th_umpic26923.jpg.gif

I need it to look like this:

th_umpic26923.gif

Can someone help me out here?

 

[grtammi]

Hmm...why even use the InStr function?

"th_" & Left([IN_Pic],(Len([IN_Pic])-4) & ".gif"

When you add the -4 part to the Len function, it will return everything except the last 4 characters, which are the .extension part...

I tested this and it works fine.

HTH

Greg Tammi, ATS
E-mail: gtammi@atsbell.com