SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I've set up the crawl to index pages based on rendered output, but now in the SELECT statement for the query, what column name can I use in the where clause?

By using a keyword search, I get results in the hithighlightedsummary column even though the title and description for the page would not contain the searched for string. I've looked at all the other columns returned and none of them would work in the FullTextSqlQuery statement.

I'd like to use the FullTextSqlQuery instead of the Keyword search in order to provide wildcard searching by using the "like" clause.

I would love to be able to use the SELECT * syntax in order to see what is available, but this isn't possible. (I know why not.)

share|improve this question

Theres lots of info out there on what columns you can use

Regarding using * wildcard in query syntax see my answer here:

AFAIK you have to specifically mention the columns you want.

In the SQL query, you are allowed to use the asterisk (*) to specify that all columns in a table are to be returned. However, no defined and fixed set of properties applies to all documents. For this reason, the SQL asterisk is not permitted in the [columns] setting.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.