How to enable full-text searching for a field

Full-text searches for a field can be enabled if the underlying database supports full-text indexing.

To enable full-text searching

1. In the Model Editor, click the SQL tab.
   
   
2. Select the table.

   Note  After making changes to the full-text index in any tables in the database, refresh the table or tables before proceeding to step 3.

3. Select the field to be enabled.
   
   
4. On the Basic tab, select Full-text indexed.

   The Search Type changes to Freetext.

5. Repeat steps 1 through 4 for each field to be included.
   
   
6. Click OK.

See Also

Basic Tab (Table/New Table Dialog Box)

Enabling Full-Text Search for an English Query Model