Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select problem
Message
From
24/02/2004 10:38:22
 
 
To
24/02/2004 10:03:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00880260
Message ID:
00880291
Views:
18

i want to return all the record stating with numeric values
So how can i do ?
Thks

the table name is clients
and the field is clients_name
* vfp
SELECT * FROM clients WHERE ISDIGIT(clients_name)
* generic
SELECT * FROM clients WHERE LEFT(clients_name,1) BETWEEN '0' AND '9'
Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform