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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search for string in a memo field

Status
Not open for further replies.

LenaS

Technical User
Nov 28, 2000
98
US
I am using Wizbtns search button to do searches and return the results in a grid. This has been working great for our needs so far. Now I have created a table with a memo field. This field does not appear in the list of available fields to search on. All I want to do is see if the memo field contains a certain character string. How can this be done? Make this an easy explanation. I'm basically a beginner. Thanks.
 
Select myTable
LOCATE FOR "myvalue" $ myTable.memofield

The $ Means the myvalue is contained in the memo field.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top