Offline Replication Filter Dialog Box

See Also

Specifies criteria for filtering the data for your offline publication. You can create a simple set of criteria for a filter using the expression builder drop-down lists, or you can build more complex criteria using SQL syntax.

To create a filter, select a main table to filter on the Filter Items tab, and then enter one or more filter clauses that compare columns in the table to some value. Only the rows in the main table that match the criteria will be replicated. For information on the T-SQL programming language, see the SQL Server Books Online.

Options

Expression

Use the drop-down boxes to create a filter. Click Add to add the expression to the SQL statement box.

For details about filtering operators, see Offline Publication Filtering Reference.

• And/Or   Available only after you have added the first expression to the SQL field.
  
  
• Column   Select a column from the main table by which to filter.
  
  
• Operator   The operators available depend on the data type of the column that is selected.
  
  
• Value   Select from existing values or type in your own. The values available depend on the column data type and the operators selected. If the Column field is bound by a foreign key constraint to a keyword lookup table, you can specify a keyword value. Values can be numbers or strings, system functions such as CURRENT USER or CURRENT TIMESTAMP, or T-SQL expressions.

SQL Statement field

When you click Add, an SQL statement is created based on the fields specified in the Expression area. After the expression is copied in the SQL area, you can modify it or click OK to add the filter to your publication. You can also type SQL statements directly into the SQL area.

Where to go from here