Trimming Numeric Values From Text.

N

Nick

I have an address field, which has the house number and
street name. Is there any way of trimming the numbers? The
number formats could vary from eg 4/79 Test Street, 3B
Test Street, or 489 Test Street.
Can I get just Test Street?

Assistance appreciated.
Nick
 
E

Edmund

If you are sure after the number, then it will follow by a space, you may use the following query!
SELECT mid(address,InStr(address," ")+1,1000) AS Streetname FROM TableNam

Edmun
MCP - Access and SQL Serve

----- Nick wrote: ----

I have an address field, which has the house number and
street name. Is there any way of trimming the numbers? The
number formats could vary from eg 4/79 Test Street, 3B
Test Street, or 489 Test Street.
Can I get just Test Street

Assistance appreciated
Nic
 
N

Nick

I tried to set up a new query by going into SQL design but
I had no luck
Can you give me a bit more detail on how to use the code?

Nick
-----Original Message-----

If you are sure after the number, then it will
Click to expand...
follow by a space, you may use the following query!!
 
Top