Trimming Numeric Values From Text.

  • Thread starter Thread starter Nick
  • Start date Start date
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
 
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
 
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!!
 
Back
Top