Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count numbers
Message
From
14/04/2008 14:12:35
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01310475
Message ID:
01310478
Views:
16
This message has been marked as the solution to the initial question of the thread.
SELECT * FROM MyTable WHERE LEN (ALLTRIM (Filed)) < 11
>the lenth of my filed(chr) is 11. some entry in this filed as =11 some are less than 11. now i want to selct records which is less than 11.
>
>in filed=345678901
>=12345678
>I want slect scond record
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform