"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 leading digits, and stops parsing
the string on the first non-digit character.
To use Val() you'd have to write code to parse the string first from pos
1, then from pos 2 and so on until a number is found.
And you would still lose the strings with more than one number.
Regards, Mats.E
--
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
:Email/ [EMAIL PROTECTED] ICQ#9517386 :
:---------------------------------------------------------------------:
:Mail/ GISKRAFT, Mats Elfstroem, Vaepplingv 21, SE-227 38 LUND, SWEDEN:
:Phones: +46 46 145959, +46 70 595 3935 :
:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]