Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine if char field in a table is a number
Message
From
27/06/2009 11:29:53
James R. Nelson
The Kong Company
Newbury Park, California, United States
 
 
To
27/06/2009 05:37:52
Marcia Akins
Arkansas, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Determine if char field in a table is a number
Miscellaneous
Thread ID:
01408688
Message ID:
01408799
Views:
73
'3.4' isn't a number?
'-3' isn't a number?


>How determine if a char field in a table contains a number ?
>
>
>IF EMPTY( CHRTRAN( MyTable.MyField, '0123456789', '' ) )
>  *** This is a number
>ENDIF
>
Jim Nelson
Newbury Park, CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform