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: Jez Enefer-Mills
  Where is Jez Enefer-Mills?
 Cornwall
 United Kingdom
 Jez Enefer-Mills
 Tags
Subject: RE: To Retrieve Specific Record from Foxpro DBF...
Thread ID: 34017 Message ID: 34191 # Views: 1 # Ratings: 0
Version: FoxPro 2.x for MSDOS Category: Databases, Tables and SQL Server
Date: Wednesday, December 10, 2003 11:42:28 AM         
   


> or you could use this
>
> "he"$fieldname
>
> this will search for the string "he" in the contents of 'fieldname'
>
>

And if you want to make this case insensitive, you can do:
"he" $ LOWER(fieldname)
or
"HE" $ UPPER(fieldname)
--
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