Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to check, what field doesn't contain digits in SQL
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Best way to check, what field doesn't contain digits in SQL
Divers
Thread ID:
00604360
Message ID:
00604360
Vues:
68
Hi everybody,

We have a phone field, which can contain phone, can be empty or can contain words "Do not call". However, these words could be changed. My original SQL was not inlist(PHONE, space(12),'Do not call'). Obviously, this would not work, if these words are going to change. So, I need to check, if I have at least one digit in a PHONE field. I'm thinking, what would be the best way of doing it in SQL. We don't have index on PHONE field, so it probably not that important...

Thanks a lot in advance.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform