Trimming an address

[tjcinnamon]

I have a table that has about 5000 street addresses (ex. 1234 your st.). I want to get the all the characters until the first space. So for (1234 Your St.) I want to get 1234 for W1234 St I want W1234. Is this possible?

 

[boblarson]

For a query put:

WhateverYouWantToCallIt:Left([YourFieldNameHere],Instr(1,[YourFieldNameHere]," ")-1)