[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

SQL SERVER 2008 EXPRESS query with CONTAINS

SQL SERVER 2008 EXPRESS EDITION:

trying to initiate this sql statement...

I have the full text catalog and index created.

use RichTextTest
SELECT [ITEM], [RICHTEXT]
  FROM RichText_test
  WHERE CONTAINS (RICHTEXT, ' "Ballast" ')

query executes but returns nothing
I have at least 15 records that have the word "BALLAST" in it ?


Thanks
fordraiders


0
Fordraiders
Asked:
Fordraiders
  • 2
2 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly confirm whether your database is CASE INSENSITIVE or not because CASE Sensitiveness might bring these kind of results..

Run this to get your Current Collation

SELECT DATABASEPROPERTYEX ( ur_db_name, 'Collation' )
0
 
wolfman007Commented:
remove the extra quote marks

i.e.

SELECT [item].[richtext]
FROM RichText_test
WHERE CONTAINS (richtext, 'Ballast')
SELECT item.richtext
FROM RichText_test
WHERE CONTAINS (richtext, 'Ballast')

Open in new window

0
 
wolfman007Commented:
Also here is an addin for SQL Server Management Studio allows you to manage your fulltext catalogs easily. It even works for SQL Server Express editions, so now you can use a nice GUI instead of using SQL commands.

http://fulltextmanager.codeplex.com/

Try making sure that the Full-Text catalog has been populated
0
 
FordraidersAuthor Commented:
Ok, Thanks, I delete my database and tok my time this time. It finally loaded the data. Did my primary index. Created my Full Text Catalog.  t-sql( I can't get the gui to display the Full Text Catalog menu option folders).

Did the suggested query. and wallaaaaa   I have data returned.. Thanks !

wolfman007, I f I have the Full Text Searching already installed. Will the install you suggested bugger it up ?





0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now