Determine if char field in a table is a number

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Determine if char field in a table is a number

Message

27/06/2009 11:29:53

27/06/2009 05:37:52

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Divers

Thread ID:

01408688

Message ID:

01408799

Vues:

'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