Problem in executing the Contains query

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

General discussion

Creator

Topic
September 1, 2004 at 4:02 am #2289482

Problem in executing the Contains query

Locked

by shabirmaher · about 17 years, 8 months ago

hi..
i have created index in SQL server 2000, but when i execute this query.
SELECT ProductName
FROM Products
WHERE CONTAINS(ProductName, ‘ “choc*” ‘)
… ProductName choc is exists in database but it does not show any record.. guide me why do’t show the record.

Shabbir

This conversation is currently closed to new comments.
Creator

Topic

All Comments

Recruiting an Operations Research Analyst with the right combination of technical expertise and experience will require a comprehensive screening process. This Hiring Kit provides an adjustable framework your business can use to find, recruit and ultimately hire the right person for the job.This hiring kit from TechRepublic Premium includes a job description, sample interview questions ...

The digital transformation required by implementing the industrial Internet of Things (IIoT) is a radical change from business as usual. This quick glossary of 30 terms and concepts relating to IIoT will help you get a handle on what IIoT is and what it can do for your business.. From the glossary’s introduction: While the ...

Procuring software packages for an organization is a complicated process that involves more than just technological knowledge. There are financial and support aspects to consider, proof of concepts to evaluate and vendor negotiations to handle. Navigating through the details of an RFP alone can be challenging, so use TechRepublic Premium’s Software Procurement Policy to establish ...

Web Development

General discussion

Problem in executing the Contains query

All Comments

How to recruit and hire an Operations Research Analyst

Quick glossary: Industrial Internet of Things

Software Procurement Policy

How to recruit and hire a Security Analyst