AbleCommerce Shopping Cart Software

I'm curious where and how FULLTEXT Search is used in AC7? In looking at the source for CatalogDataSource and SearchDataSource, everything appears to be using a standard SQL LIKE operator.

The reason I am interested is because I need to perform a FULLTEXT search on the webpages table within the Name, Title, and Description columns. When I attempt to do so, I get the following error:

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'ac_Webpages' because it is not full-text indexed.

I could use the CatalogDataSource.Search method, but it doesn't load all of the columns I need, with means I'd need to run another query for every result to get the details

When I customized a site for that, I had to add webpages to the full text search catalog in the database. You can do that directly in the database or via code. If you do it directly, be aware that if someone changes the search settings in the admin to non-full text search, it will remove the full text search catalog.

Thanks Judy, I'll look into it.

Thanks Judy. Added FULLTEXT search with the following Transact-SQL:
Things are working now