Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best way to check, what field doesn't contain digits in SQL
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Best way to check, what field doesn't contain digits in SQL
Miscellaneous
Thread ID:
00604360
Message ID:
00604360
Views:
69
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
Next
Reply
Map
View

Click here to load this message in the networking platform