Home

DBF Viewer 2000 - Online Help

Introduction Hotkeys Command line options Working with databases Opening DBF files Creating New DBF file Modifying file structure Viewing satistics Import/Append records Save As/Export Working with records Adding records Editing records Deleting records Replacing records Filling records Sorting records Searching and Filtering Searching by criteria Filtering records Commands File Edit View Tools Options Information Support How to purchase

Searching by criteria [Previous] [Main] [Next] You may searching for records meeting the specified parameters. To set criteria for searching records, click Edit | Find menu, or click the corresponding icon on the toolbar. Find dialog box opens. Set the criteria for necessary fields and click OK. To find next entry, click Edit | Find Next menu, or click F3. You can use the following metasymbols in search expressions: · ?-any character in current position   · *-any characters after '*'   · *aa- search "aa" in any position   ·   Example    Matches    Doesn't Match ab*       abc       cab a?b*       aabc       aadc *ab       cab,abc    cba >, >=, <, <= Example: >=100 <10 You can set range for date/Timestamp fields and all numeric types. Special macros: empty() - find records with empty fields ! find with not equal value Example: !Peter records with field not equal Peter !empty() records with not empty field. multiple search criteria: peter or jhon or mike