In the Table Editor, you can use SQL statements to restrict the contents of a list window to those that match certain criteria. The Table Editor does not let you use full SQL statements; however, it does let you use basic “where” clauses to locate specific information. This section explains the basic concepts you need to understand about where clauses and explains how to use a “where” clause to search for rows.
This section explains these topics:
• | Where Clause Formula |
• | Table Columns and Values |
• | Basic SQL Grammar |
• | Using a Where Clause to Search for Rows |
© 1998-2017 Sirsi Corporation