getting left values

[Aussie John]

Hi i want to extract a number before a "_" eg 1_, 2_, 22_

using the left function only gives me the first number not the double digit.

where do I go from here thanks?

[-Queue-]

Left( field, Position( field, "_", 1, 1 ) - 1 )

This calculates the position of the underscore and gives all characters to the left of it.

[Aussie John]

Thanks Id look at the help file a bit better but am running of time today