Compare field to file folder name on server

[new_2_prog]

I have a field JobNum (i.e. 6465) that I need to find its folder on the server but the catch is the folder has the year (08,09,etc) in front of the JobNum.
How can I skip the first 2 digits of the folder and compare just the next 4 digits to find a match?
Is there a way to take in the folder name in a variable and look for a match?

Thanks!
Stacey

 

[wiklendt]

you could use the 'left' 'right' and 'middle' operands to truncate your folder name variables, then compare them to the field...