Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Free Text Search issue ?!

 
   Database Forums (Home) -> Full Text RSS
Next:  using insert with output  
Author Message
Pat.Rick

External


Since: Jul 12, 2010
Posts: 1



(Msg. 1) Posted: Mon Jul 12, 2010 1:31 pm
Post subject: Free Text Search issue ?!
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

Hi Friends,
SQL 2008 FTS

Why my FTS doesn't return the following data set while using like
does !

Dataset 1:
select * from lo_text lt where lt.title like '%123%'
LEAD0123001002000X820001
CONS8123001001000X820001
Q2 Mandatory Training 2010 (123)

Dataset 2:
select * from lo_text lt where FREETEXT (lt.title,'123')
Q2 Mandatory Training 2010 (123)

I also tried select * from lo_text lt where FREETEXT
(lt.title,'"*123*"'), but still no result

Thanks in advance,
Pat

 >> Stay informed about: Free Text Search issue ?! 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Free-Text Search "AND NOT" Wrong results - HELP, please! - Hi, I have a Photo Database, with a Photo table. Each photo has several Varchar fields for storing caption, description, keywords, etc. I have a Full-Text index/catalog for these fields. This is the problem: I want to find all photos that are related t...

An issue with Full Text Search against PDF blobs... - My client is trying to use SQL Server Full Text Search to search PDFs stored in a varbinary(max) column. Full text search works fine for other Microsoft Office documents stored in the same table but it does NOT give back any results from the PDF..

SQL 2000 Full Text Search - Hi all, Appologies if this has been asked before, I have been searching for days now on how to do this without success. We have a database we would like users to be able to search I have enabled full text search and it works great but I cannot figure..

WSS, SQL 2005 and Full Text Search - I am having a problem getting SharePoint Service to acknowlwdge that Full Text Search is enabled. I upgraded the SharePoint MSDE database as documented without any problems, but when I go into SharePoint Admin section is says "The database this s...

Full-text Search - Hello, I have a full-text enabled field in my table has the following content as an example: "SQL Server is a comprehensive, integrated, end-to-end data solution that empowers your people by providing a more secure, reliable, and productive platfor...
   Database Forums (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]