problem with content() in full text search

Question

0.00/5 (No votes)

See more:

What Is equal of this select with contains()?

SQL

select * from student
where name like '%a%'

plz F1F1F1F1

Posted 23-Mar-13 2:15am

mojtaba391

Add a Solution

Comments

RedDk 23-Mar-13 13:40pm

The predicate CONTAINS() can't be used on anything other than a FULLTEXT cataloged table ... set that up by creating a FULLTEXTT INDEX. The index is not a default quality.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-03-23T02:29:00

Solution 1

Try:

SQL

SELECT * FROM student WHERE CONTAINS(name, "a")

Posted 23-Mar-13 2:29am

OriginalGriff

Comments

mojtaba391 23-Mar-13 9:05am

Your answer did not work

OriginalGriff 23-Mar-13 9:27am

Not a very helpful response.
What did it do? What didn't it do? Any messages? How did you use it?
Remember, I can't see your screen!

problem with content() in full text search

1 solution

Solution 1

Add your solution here

Preview 0

problem with content() in full text search

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us