A bit long winded but try using the following in the SQL Select selection
criteria:-
MY_TABLE Like "%1%" or MY_TABLE Like "%2%" or MY_TABLE Like "%3%" or
MY_TABLE Like "%4%" or MY_TABLE Like "%5%" or MY_TABLE Like "%6%" or
MY_TABLE Like "%7%" or MY_TABLE Like "%8%" or MY_TABLE Like "%9%" or
MY_TABLE Like "%0%"
Tim Chinchen (GIS Systems Developer)
I.T. Services Bournemouth Borough Council
Mailto:[EMAIL PROTECTED]
> -----Original Message-----
> From: Tom Manson [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, November 12, 1999 11:40 AM
> To: 'MapInfo'
> Subject: MI - selecting number within text
>
> Dear list,
>
> Second problem in two days, so here goes.....
>
> I have a character column, although some of the records have numbers in
> them. How do I go about just selecting those records with a number in the
> text?
>
> My records look something like this:
>
> leak on 4in main
> burst main
> burst 10 inch
>
> In other words, the numbers do not always appear in the same place. So how
> can I just select those records with values in using SQL?
>
>
> Many thanks in advance,
>
>
> Tom
>
> ps Enjoy the weekend and England's victory over our northern
> neighbours!!!!
>
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.bournemouth.gov.uk
**********************************************************************
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
