Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locate the records
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00954531
Message ID:
00954536
Views:
10
>How a record can be loate from table.
>e.g
>He is man of God
>
>i want to loacte the record, which record have word"man"
>thanks

If You want just to LOCATE the record:
LOCATE FOR "MAN" $ UPPER(FieldOfTable)
If You want to get All the records:
SELECT YourTable.* FROM YourTable WHERE FieldOfTable LIKE "%man%" ...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform