--- title: "Enable List Where Clause" slug: "enable-list-where-clause" updated: 2024-03-29T13:09:34Z published: 2024-03-29T13:09:34Z canonical: "skthelp.syniti.com/enable-list-where-clause" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Enable List Where Clause Add a list Where Clause to restrict the values that display in a list box or combo box. Refer to [Add List Boxes and Combo Boxes](/v1/docs/add-list-boxes-and-combo-boxes) for general information. To create a List Where Clause: 1. [Access the Page Columns page](/v1/docs/access-the-column-properties-page) *Vertical* View for a list box or combo box. 2. Click **Edit**. [*View the field descriptions for the Page Columns page*](/v1/docs/page-columns-h) 3. Click the **Advanced Properties** tab. 4. Enter the WHERE clause in the **List Where Clause** field. 5. Click **Save**. > [!NOTE] > Note > > For nvarchar and nchar database fields, the **N** must be prepended to string literals in Where Clauses so Unicode characters will not be lost and the value must have single quotes on either side. This is unnecessary for numeric fields.s