<div>
Thanks chaau - I didn't realise that I needed * and double quotes in CONTAINS instead of %
</div>


Thanks chaau - I didn't realise that I needed * and double quotes in CONTAINS instead of %

<div>
<div class="content wysiwyg-content">
I know how to use contains to produce results if for example I type CONTAINS(&lt;fieldname&gt;,'Admi<wbr />nistration<wbr /> AND Reception'), but how can I get results if I want to match partial words - <br />
<br />
I have tried CONTAINS('Admin% AND Recept%') which doesn't work.<br />
&nbsp; <br />
I Have also tried &lt;fieldname&gt; LIKE 'Admin%' AND&lt;fieldname&gt; LIKE 'Recept%', but that doesn't work either.<br />
<br />
I need to find documents which contain <u>both</u> words.
</div>
</div>


I know how to use contains to produce results if for example I type CONTAINS(<fieldname>,'Administration AND Reception'), but how can I get results if I want to match partial words - 

I have tried CONTAINS('Admin% AND Recept%') which doesn't work.
  
I Have also tried <fieldname> LIKE 'Admin%' AND<fieldname> LIKE 'Recept%', but that doesn't work either.

I need to find documents which contain both words.

Using Contains with wildcards in SQL query

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.