Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Free Text Search issue ?!
3 views
Skip to first unread message
Pat.Rick
Jul 12, 2010, 4:31:09 PM7/12/10
to
Hi Friends,
SQL 2008 FTS
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
0 new messages