FREETEXTTABLE question

i never seem to get the basics, but once i do it all falls into place.
this query is simple, but doesn't work and i'm sure someone will tell me why.
declare @.term as varchar(50)
set @.term = 'car repair'
select u.usrCompany
from usr u
inner join FREETEXTTABLE(usrBusDesc, 'car repair') ft on u.usrid = ft.usrid
the error is: Msg 170, Level 15, State 1, Line 10
Line 10: Incorrect syntax near 'car repair'.
just can't seem to get it. Must be a Yew Years Thing
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
and... This always has a habit of happening
I figure it out within a min. of my posting!
I needed to include the table name!!!!
select u.usrCompany
from usr u
inner join FREETEXTTABLE(usr, usrBusDesc, 'car repair') ft on u.usrid =
ft.[KEY]
thanks (as always)
some day i''m gona pay this forum back for all the help i''m getting
kes
"WebBuilder451" wrote:

> i never seem to get the basics, but once i do it all falls into place.
> this query is simple, but doesn't work and i'm sure someone will tell me why.
> declare @.term as varchar(50)
> set @.term = 'car repair'
> select u.usrCompany
> from usr u
> inner join FREETEXTTABLE(usrBusDesc, 'car repair') ft on u.usrid = ft.usrid
> the error is: Msg 170, Level 15, State 1, Line 10
> Line 10: Incorrect syntax near 'car repair'.
> just can't seem to get it. Must be a Yew Years Thing
> --
> thanks (as always)
> some day i''m gona pay this forum back for all the help i''m getting
> kes