Hi Alan,
If you've got a table with a field called Address in it, you can use the
following:
Right$(Address, Len(Address)-Instr(1,Address," "))
This finds the location of the first blank space, and returns everything
that follows it. Hope this helps.
Ronan.
-----Original Message-----
From: Alan Gunn [mailto:[EMAIL PROTECTED]
Sent: 30 August 2005 20:41
To: [email protected]
Subject: MI-L extracting street name
Hello all,
Someone told me how to do this once and now I can't find it anywhere.
Sorry.
I need to pull the street name out of a column that has both the address
number and street name. Any suggestions?
Thanks
Alan
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 17676
