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 - 2000-09-14 : 21:29:52
|
Shawn writes "Hi Gurus!!
I want to know the SQL statement that will allow me to search for the word ASP+ using SQL 7 Full Text Searching.
Here's a simple example of what I'm looking for:
SELECT col FROM Table WHERE CONTAINS(*, '"ASP+"')
The above example returns all rows where any of the columns on my table marked with indexing match ASP. The plus character is always ignored in this syntax.
Thanks!
Shawn"
|
|
|
|
|
|
Full Text Seaching for plus character