Trimming an address

tjcinnamon

Registered User.
Local time
Today, 16:22
Joined
Jan 26, 2006
Messages
66
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?
 
For a query put:

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

Users who are viewing this thread

Back
Top Bottom