Dear Mat, Tim, Tom and all,
Oops!
Sorry you are right. It was a bit late when I sent that answer and I
wasn't thinking straight. Although Val() will strip of trailing text
leaving just the number that was at the front, it will only work when
the number is at the front!
I'll think a bit harder n
I am not quite sure what mat is referring too (I lost the former threads),
but searchtxt.bmx at :
http://std.cpc.ku.ac.th/delta/deltacp/free/free4.htm
allows tou to select objects which have a given string within a given field
(typically a keywork in a comment, summary, text, etc.)
pancho
Mats El
"Bob Young - www.bydesignwales.demon.co.uk" wrote:
>
> 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.
Hi Bob!
I believe that Val() only evaluates leadin
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 <[EMA
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_TA
Search for records with characters in that have ascii values in the
appropriate range (I'm not sure off the top of my head what the acsii
values for 0-9 are). This could be done easily in MapBasic, but I'm
not sure about in MI Pro directly...
[England 2 - Scotland 0, I reckon]
> This message