How to filter publications horizontally using the Create Publication Wizard (Enterprise Manager)

How to filter publications horizontally using the Create Publication Wizard (Enterprise Manager)

1. In the Create Publication Wizard, on the Customize the Properties of the Publication page, select Yes, I will define data filters, enable anonymous subscriptions, or customize other properties.
   
   
2. On the Filter Data page, select Horizontally, by filtering the rows of published data.
   
   
3. On the Filter Table Rows page, click the Filter Clause (...) button next to the article you want to filter, and then in the Specify Filter dialog box, complete the WHERE clause with a condition for the filter.

Note  This is not the page to enter join filters that cross tables based on relationships between tables. That page in the Create Publication Wizard is called Generate Filters Automatically.