Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filtering/Searching Records

Status
Not open for further replies.

jerold

Programmer
Aug 30, 2000
52
PH
How do I make a search or filter on records
using operator like "in" and "between"?
Lets say I have a _text.
I want to look for the fields that have this _text
in or between its string. [sig][/sig]
 
Check out the AT or ATC commands...

ATC(cSearchFor,cSearchIn)

Returns 0 if not found otherwise the location of the first occurance of cSearchFor in cSearchIn.

So in SQL statement you might have where clause like...

WHERE ATC('ABC',Table.Field)>0

Enjoy. [sig]<p> Pete<br><a href=mailto:blindpete@mail.com>blindpete@mail.com</a><br><a href= > </a><br>What your mother told you is true! You will go blind! (from moonshine anyway)[/sig]
 
You can also use
$
AT()
ATLINE()
ATC()
AT_C()
ATCC()
ATCLINE()

[sig]<p>David W. Grewe<br><a href=mailto:Dave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br> [/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top