Find Function from excel in an Access Query 1

[gregmw]

I am having trouble converting a simple expression in excel to access. The formula in excel is

=(LEFT(J25,FIND("|",J25)-1))

in access do you know what the equivalent FIND function is?

Thanks
Greg

 

[gol4]

Perhaps Instr()is what you are looking for

left("text",instr("text","|")-1)

 

[gregmw]

Thanks that is the function I need to use.