Queries :: Expression To Remove TIF Extension

How to create an expression that removes the ".tif" extension of a file path.The data looks like this in it raw form:

J:201303080056273_ELECTRICALRETAILER_00100562 73_ELECTRICALRETAILER_001_3.tif

In my query grid in the filed row I have the following:

ImageRef: Mid([strImagePath],111,38)

which produces the following:

00056273_ELECTRICALRETAILER_001_3.tif
00056273_ELECTRICALRETAILER_001_31.tif

and so on...

What I need to do is remove the ".tif" part of the data. because of the way the path is output with regards to the tif image number, I'm having difficulty in targeting only that data that comes before the ".tif" extension.Is there a method I can use that will remove the right 4 characters and in conjunction with my expression above produce the following:

00056273_ELECTRICALRETAILER_001_3
00056273_ELECTRICALRETAILER_001_31

I've managed to work out how to get the data without the file extension ".tif" with the following expression:

ImageRef1: Left([strImagePath],Len([strImagePath])-4)

which gives me the following:

domgennt.dggroup.comglobalResourceApplication sUNIeFlowIMAGES201303080056273_ELECTRICALRET AILER_0010056273_ELECTRICALRETAILER_001_3

and

domgennt.dggroup.comglobalResourceApplication sUNIeFlowIMAGES201303080056273_ELECTRICALRET AILER_0010056273_ELECTRICALRETAILER_001_31

How can I combine the following expression with the above expression to get what I need:

Combine - Mid([strImagePath],111,38) with Left([strImagePath],Len([strImagePath])-4)

to get this result:

00056273_ELECTRICALRETAILER_001_3
00056273_ELECTRICALRETAILER_001_31