'CONTAINS' IS NOT A RECOGNIZED FUNCTION NAME

[Nii Larnyoh]

I am getting this error:
"'CONTAINS' IS NOT A RECOGNIZED FUNCTION NAME"
when I issue a select query with the 'contains' keyword.

Please help.

[msnews.microsoft.com]

Try Like %ZZZ% instead. This should return anything that contains ZZZ.

Nii Larnyoh wrote in message <36CC2FC7...@anglo.co.uk>...

[Kalen Delaney]

CONTAINS is only recognized if you have set up full text indexing
capabilities on your table/using the Full text search service. This is a
separate entity in SQL 7, but it is available through the Enterprise
Manager, if you've installed it.

You have to choose Custom Install to get Full Text Search capabilities.

HTH

--
Kalen Delaney
MCSE, SQL Server MCT, MVP
(Please do not send email.
Post all followups to the newsgroups.)

[Nii Larnyoh]

I have installed the full text search service. But still no joy.
This is the SQL:
select * from jabbyjab where contains(jabby,'Marcaroni')

note: jabby is the text indexed column name

[Nii Larnyoh]

[Nii Larnyoh]

[Kalen Delaney]

This is the message you get when you have not properly built the full text
index on the column in the CONTAINS list. So you might try rerunning the
wizard to make sure you have that column indexed.

There is a slight syntax problem, but I didn't think that would give the
error you reported. You need two sets of quotes. You use double quotes to
delimit the entire set of search parameters, which can be quite a bit more
complex than one simple string, and you need single quotes around individual
strings within the search parameters. So even if you have only one simple
string, you need both sets of quotes.

select * from jabbyjab where contains(jabby, " 'Marcaroni' ")

HTH

--
Kalen Delaney
MCSE, SQL Server MCT, MVP
(Please do not send email.
Post all followups to the newsgroups.)

Nii Larnyoh wrote in message <36CD6413...@anglo.co.uk>...

[Dwayne Lanclos]

Is is possible that 6.5 database compatibility is turned on?

Nii Larnyoh wrote in message <36CD643A...@anglo.co.uk>...