Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Robin George
  Where is Robin George?
 Dammam
 Saudi Arabia
 Robin George
 Tags
Subject: To Retrieve Specific Record from Foxpro DBF FILE
Thread ID: 34017 Message ID: 34017 # Views: 1 # Ratings: 0
Version: FoxPro 2.x for MSDOS Category: Databases, Tables and SQL Server
Date: Saturday, December 06, 2003 2:08:30 PM         
   



Robin George
Generally in SQL , we have the 'Like' operator that is used in the where condition of a sql statement to retrieve records
from a table based on a field for which we are not sure about the value or don't know the complete value.
for ex :: select Phone_no from Regitry_Tab where name like 'R%'
This retrieves all the phone no from the table where the name field starts with R.

Can a similar technique be used in Foxpro 2.5.. to retrieve records from the DBF file.
Because I know only a part of a particular field in the DBF file.
Please Help.
Thank You

ENTIRE THREAD

To Retrieve Specific Record from Foxpro DBF FILE Posted by Robin George @ 12/6/2003 2:08:30 PM
RE: To Retrieve Specific Record from Foxpro DBF... Posted by Eric den Doop @ 12/6/2003 3:06:40 PM
RE: To Retrieve Specific Record from Foxpro DBF... Posted by Stuart Rosen @ 12/7/2003 10:29:25 PM
RE: To Retrieve Specific Record from Foxpro DBF... Posted by Robin George @ 12/10/2003 11:01:38 AM
RE: To Retrieve Specific Record from Foxpro DBF... Posted by Jez Enefer-Mills @ 12/10/2003 11:14:27 AM
RE: To Retrieve Specific Record from Foxpro DBF... Posted by Eric den Doop @ 12/10/2003 11:42:28 AM