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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-03 : 09:02:24
|
| Paul writes "What is the proper syntax for using a parameter in the CONTAINS clause of a full-text search. I'd been using code like:WHERE Artist LIKE '%' + @strSearch + '%'but wanted to stop doing table scans. I've got my SQL server all set up for full-text search but when recoding the WHERE clause, I can't seem to find the correct use of quotes and apostrophies? I'd assumed it would change to something like this: WHERE CONTAINS(Artist, '" + @strSearch + "'), but obviously this doesn't work correctly. Running the stored procedure from query analyzer works fine if I substitute the parameter with '"search string"' so I know that the catalog is working properly. Can someone offer some insight on this situation? Thanks." |
|
|
|
|
|
Using parameters in full-text search.