SEARCH FOR column_name(s) IN table_name. OCCURS WHERE. Using the where condition, choose the column name from the table name.
ExampleTake ownership of a SQL Server. Choose SupplierName. VARIOUS SUPPLIERS.
Example. SEARCH FOR SupplierName IN Suppliers.