List,
I have a file that contains entries like 'O/S 17 Some Street' and I need to
extract the house number. I know it involves the InStr() function but can't
work it out fully. Could someone please provide a 'snippet' for an SQL.
Thank you all.
Mark Percival
mailto:[EMAIL PROTECTED]
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service. For further
information visit http://www.star.net.uk/stats.asp or alternatively call
01285 884400.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.