Re: Different columns

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Does this work for you?

create table titles(id int identity not null constraint titlespk primary
key,INDEKS varchar(50),TEKST varchar(50))
GO
insert into titles(indeks,tekst) values('World War','Day by Day')
insert into titles(indeks,tekst) values('World War Day','test')
insert into titles(indeks,tekst) values('test','World Way Day')
GO
create fulltext catalog test as default
GO
create fulltext index on titles(indeks,tekst) key index titlespk
Go
select * from titles
join containstable(titles,indeks,'War') as a on a.[key]=id
join containstable(titles,tekst,'day') as b on titles.id=b.[key]
GO

--
http://www.zetainteractive.com - Shift Happens!

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Meelis Lilbok" <meelis.lilbok@xxxxxxxxxx> wrote in message
news:us8CkB1PIHA.3676@xxxxxxxxxxxxxxxxxxxxxxx
Hi !

Lets say i have a table TITLES with columns ID,INDEKS,TEKST
Values in row are
ID INDEKS TEKST
1 World War II Day by Day

now is use query


SELECT * FROM TITLES T INNER JOIN CONTAINSTABLE(TITLES,*,'"war" and
"day"') CT
ON T.ID=CT.[KEY]

This query returns nothing because word "war" is in column INDEKS and word
"day" is in column "TEKST"!


Is there any solusion?


Best regards;
Meelis




.

Relevant Pages

  • Re: Different columns
    ... The problem is when i use query ... I need get result when word "war" is in field INDEKS and word "day" is in field TEKST ... This query returns nothing because word "war" is in column INDEKS and word ...
    (microsoft.public.sqlserver.fulltext)
  • Different columns
    ... Lets say i have a table TITLES with columns ID,INDEKS,TEKST ... World War II Day by Day ... This query returns nothing because word "war" is in column INDEKS and word ... Best regards; ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Different columns
    ... INDEKS column is indexed part for book titles ... TEKST column is for text. ... with containstable i get nothing back, beacuse "war" is on INDEKS and "day" is on TEKST ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Different columns
    ... TEKST column is for text. ... insert into titlesvalues('World War Day','test') ... GO create fulltext catalog test as default ... Go select * from titles join containstableas a ...
    (microsoft.public.sqlserver.fulltext)
  • The UKRM DVD Buyers Club
    ... I've bought stuff from them before, ... of titles that may be of interest to UKRMers as they've ... about men at war ever produced in Britain, Piece of Cake ...
    (uk.rec.motorcycles)