Filtering/Searching Records

[jerold]

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]

 

[BlindPete]

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]

 

[dgrewe]

You can also use
$
AT()
ATLINE()
ATC()
AT_C()
ATCC()
ATCLINE()

[sig]<p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br> [/sig]