Solved

Using Contains with wildcards in SQL query

Posted on 2014-07-22
2
150 Views
Last Modified: 2014-07-22
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.
0
Comment
Question by:jdthedj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
chaau earned 500 total points
ID: 40213259
You can either use:
 CONTAINS(<fieldname>, '"Admin*" AND "Recept*"') 

Open in new window

or
<fieldname> LIKE '% Admin%' AND<fieldname> LIKE '% Recept%'

Open in new window

The latter will not be using FULL TEXT SEARCH and would be slower in my opinion
0
 
LVL 3

Author Closing Comment

by:jdthedj
ID: 40213269
Thanks chaau - I didn't realise that I needed * and double quotes in CONTAINS instead of %
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question