Hi Mark,
If you are sure your address column is like 'O/S 17 Some Street' , you can use:
select Mid$(address_column,5,2) from address_table into selection
in a sql query. It wil return 17 in this case.
Mid$() returns part of a string. 5 because the part begins at the fifth character and
t; From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, June 13, 2001 4:13 PM
> To: [EMAIL PROTECTED]
> Subject: MI-L Finding numbers in string
>
> List,
>
> I have a file that contains entries like 'O/S 17 Some Street' and I need
> to
> ext
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]
___