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.
| Author |
Topic |
|
ppuar
Starting Member
28 Posts |
 Posted - 2002-01-11 : 18:13:41
|
| Trying to figure out why I keep on getting an error messageDECLARE @SearchWord varchar(30)SET @SearchWord = 'test'SELECT vchCompanyName FROM icsF1500List WHERE FREETEXT(*, @SearchWord)Server: Msg 170, Level 15, State 1, Line 3Line 3: Incorrect syntax near '@SearchWord'.ThanksP |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-11 : 18:57:50
|
| Did you hilight and run it? I just ran it, and it worked fine, but if you hilight it and leave off the last ) I get the error that you got. Make sure you are running exactly what you put in the post.HTH-Chad |
 |
|
|
ppuar
Starting Member
28 Posts |
Posted - 2002-01-11 : 19:06:35
|
| I am using SQL 7 - and it does work ing SQL 2000 |
|
|
|
|
|
|
Freetext Search