Syntax: %find(s[,view,col]))

returns a list of records in a database whose first column contains the string s. If view is specified, it is a string list whose first value is the name of the View to search, and optional second item is the two-character database name. Col is the name of the column to search instead of the first column and is optional. The string list that is returned is a list of record numbers with the database name attached.


If records 8 and 20 in the Potions view have a name in the first column containing the word "blue", then

#SHOW %find("blue",Potions)

would return the list 8eq|20eq

Contents filesize format