Searching for keywords in fulltext indexes using the "contains" function Lets assume "and" is not a stopword, in my language it should not be.

How do I search for it using the contains function?

It is a keyword, but how do I escape the keywordness?

No luck with:

SELECT pc.SearchData, from PageContent pc
where contains(pc.SearchData, 'AND')


(got no search hits) or

SELECT pc.SearchData, from PageContent pc
where contains(pc.SearchData, '[AND]')


(this was giving me an exception)...
If you believe that &quot;AND&quot; should not be considered a stop word by SQL DB Engine while performing full-text index search, you need to configure it accordingly.
From CONTAINS description.

The search for characters in the word or phrase is not case-sensitive. Noise words (or stopwords) (such as a, and, or the) in full-text indexed columns are not stored in the full-text index.
If a noise word is used in a single word search, SQL Server returns an error message indicating that the query contains only noise words.
SQL Server includes a standard list of noise words in the directory \Mssql\Binn\FTERef of each instance of SQL Server.

You need to edit \Mssql\Binn\FTERef location manually to remove AND from the list of stopwords.
Here is MSDN resource:
CONTAINS
Configure and Manage Stopwords and Stoplists for Full-Text Search