get all text before character
I need to take a database field and pull out with a calculation all words/characters before the occurance of a hyphen.
I am thinking this will begin with Left ( text ; numberOfCharacters ) then determine the space from the left that the hyphen falls but this is where I am stuck.
I should add that sometimes the desired result will be a single number but sometimes it may be a number and some text. Maybe Left() is not going to work.