VERIFIED SOLUTION i

How to test if a value is of a numeric or character data type using Mapbasic

Products affected: MapBasic™
 
One way to do this is using the ASC function to return a value and then a simple condition test to check if the value indicates a numeric.

For example:


Dim strTest as string
Dim intValue as integer

strTest = "12 Smith St"
intValue = ASC(Left$(strTest,1))

If intValue > 47 and intValue < 58 then
'first character is a number

End If


An ASCII value of 48 - 57 indicates a numeric character, all other values are non-numeric.
UPDATED:  September 19, 2017