Deleting text from string

[SpringK]

I have a field in my invoicing table with values as follows

34 feet
145 feet
12345 feet

I need to be able to pull the numeric part of the field out so that I can use it in computations.

I've tried strA - Right(strA,5), but it doesn't work.

The 'space' and 'feet' is consistent with all the field values, but I do not know how long the number value will be.

Thanks for your help in advance.

 

[RoyVidar]

Try the Val() function:

[tt]msgbox val(strA)[/tt]

Roy-Vidar