FULL TEXT SEARCH - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

FULL TEXT SEARCH

Author

Topic

jadoger
Starting Member

13 Posts

Posted - 2004-07-14 : 04:52:57

all what I want to do is assign a value to a varible from a select query and then use that variable in freetext() or contains(), when I assign value explicitly it works but not when I assign a value to a variable from query e.g.

IT WORKS !

Declare @vTemp varchar(50)
SET @vTemp = '"Nash-Oblien"'
SELECT distinct * From temp
where
freetext(fullname, @vTemp) and
freetext(address,'14 Marchmont Rd') AND contains(zip,'"SM6 9NU"')

DONT WORK!

Declare @vTemp varchar(50)
SET @vTemp = (Select TOP 1 Name FROM NameTable)
SELECT distinct * From temp
where
freetext(fullname, @vTemp) and
freetext(address,'14 Marchmont Rd') AND contains(zip,'"SM6 9NU"')

it gives me error, can any one help regarding this ?

jadoger

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources