• Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

FullText Search - SQL Server

Yes but the wildcard doesn't work. I'm sure I mentioned this before. :D

I've not recommended the bloody wildcard. :fight:

I'm telling you that Attrn is not a natural stem from Att so you won't get a result, which is the correct behaviour.

To get Attrn in your result set, you'd have to use like %Att% in your where clause instead.
 
Because you either need a "*" wildcard or to include something extra like FORMSOF, INFLECTIONAL and / or FREETEXT rather than just CONTAINS.

That's the opposite of what you said :confused:

What's syntax are you using for your wildcard match?

I've not recommended the bloody wildcard. :fight:

I'm telling you that Attrn is not a natural stem from Att so you won't get a result, which is the correct behaviour.

To get Attrn in your result set, you'd have to use like %Att% in your where clause instead.

Sorry LM, no you didn't. Others did.

I have read your link and understand what you are telling me, finally. :smile
 
Sorry LM, no you didn't. Others did.

I have read your link and understand what you are telling me, finally. :smile

Are you aware that you need wildcard when searching for something that's not a stem?

Since Att isn't a stem of Attrn, you need to use a wildcard.
 
Are you aware that you need wildcard when searching for something that's not a stem?

Since Att isn't a stem of Attrn, you need to use a wildcard.

Ah yes, except wild cards did not work.
 

Advertisers

Back
Top