Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stuart Rosen
  Where is Stuart Rosen?
 Melbourne
 Australia
 Stuart Rosen
 To: Eric den Doop
  Where is Eric den Doop?
 Houten
 Netherlands
 Eric den Doop
 Tags
Subject: RE: To Retrieve Specific Record from Foxpro DBF...
Thread ID: 34017 Message ID: 34046 # Views: 1 # Ratings: 0
Version: FoxPro 2.x for MSDOS Category: Databases, Tables and SQL Server
Date: Sunday, December 07, 2003 10:29:25 PM         
   


In fox 2.6 (not 100% sure about 2.5) you could also use the '$' operator.....

Eg. Select * from from Regitry_tab where 'R' $ UPPER(name). This is the same as using like '%R%'.

> >
> > 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