Re: MI - selecting number within text

[Bob Young - www.bydesignwales.demon.co.uk]

Dear Tim and Tom

Only snag with this approach is that "F1 Racer" and other strings with
numbers in will comme back too.

You could try where val(recString) > 0 as an alternative.

HTH!

Regards

Bob




In message <31519CDE0AFAD11182BF00805F85F95D8EF9F4@CS-EXCHANGE>, Timothy
Chinchen Cen-IT <[EMAIL PROTECTED]> writes
>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]

-- 
Bob Young - www.bydesignwales.demon.co.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]