Originally posted by MrMarkyMark
View Post
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- 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
Collapse
X
-
The greatest trick the devil ever pulled was convincing the world that he didn't exist -
Originally posted by LondonManc View PostAtt with CONTAINS or FREETEXT should turn up the row where a correctly indexed column contains Att (no wildcards needed).
I should add though I was explicitly talking about eh Like search string he posted.The Chunt of Chunts.Comment
-
Originally posted by MrMarkyMark View PostWhy would it???
% just looks for Unknowns at the end of your string?
The "r" isn't at the end..
I did actually meanCode:Like '%attrn'
Knock first as I might be balancing my chakras.Comment
-
Originally posted by suityou01 View PostIn the process of coding, and then popping back here to answer queries, I made a mistake.
I did actually meanCode:Like '%attrn'
The Chunt of Chunts.Comment
-
Originally posted by suityou01 View PostI did do the following
Code:ALTER FULLTEXT INDEX ON MyFullTextTable SET STOPLIST = OFF
Code:ALTER FULLTEXT INDEX ON MyFullTextTable START FULL POPULATION
The greatest trick the devil ever pulled was convincing the world that he didn't existComment
-
Originally posted by LondonManc View PostRun this and see if it works after that:
Code:ALTER FULLTEXT INDEX ON MyFullTextTable START FULL POPULATION
I tried and got this.
Warning: Request to start a full-text index population on table or indexed view MyFullTextTable' is ignored because a population is currently active for this table or indexed view.Knock first as I might be balancing my chakras.Comment
-
Originally posted by MrMarkyMark View PostOK, but may be worth considering LMs comment..
Eg 'Attn' is contained in the string 'Attrn'Knock first as I might be balancing my chakras.Comment
-
Originally posted by suityou01 View PostThank you LM.
I tried and got this.
Have you used CHARINDEX to see what rows contain 'Att'?
e.g.
Code:SELECT TOP 20 * FROM MyFullTextTable WHERE CHARINDEX('Att', TextColumn) >0
The greatest trick the devil ever pulled was convincing the world that he didn't existComment
-
Originally posted by LondonManc View PostAh okay, so you've already got one.
Have you used CHARINDEX to see what rows contain 'Att'?
e.g.
Code:SELECT TOP 20 * FROM MyFullTextTable WHERE CHARINDEX('Att', TextColumn) >0
Knock first as I might be balancing my chakras.Comment
-
In summary then, CONTAINS(YourColumn,'Att') doesn't work but CHARINDEX('Att', Yourcolumn) >0 gets results?
You've created the full-text catalog?
You've created the full-text index on the table and correctly associated it with the catalog above?
Have you tried doing it by using the wizard in SSMS?The greatest trick the devil ever pulled was convincing the world that he didn't existComment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment