Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 To: Robin George
  Where is Robin George?
 Dammam
 Saudi Arabia
 Robin George
 Tags
Subject: RE: To Retrieve Specific Record from Foxpro DBF...
Thread ID: 34017 Message ID: 34020 # Views: 1 # Ratings: 0
Version: FoxPro 2.x for MSDOS Category: Databases, Tables and SQL Server
Date: Saturday, December 06, 2003 3:06:40 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

If I remember correctly, fox 2.5 does not support the LIKE argument. You need to use functions like LEFT(), RIGHT() or SUBSTR() instead:
select Phone_no from Regitry_Tab where left(name, 1) = "R"


--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts

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