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 |
|
Albertraj
Starting Member
1 Post |
 Posted - 2009-06-19 : 08:55:46
|
| i had a table with two columns id and description.In Stored procedure we used contains function for searching the text.We need the search the text like 'Reference and Terminology'but we didnot get the result even if records are there in database.SELECT * FROM tabl_1 WITH(NOLOCK) WHERE CONTAINS(description, '"*Reference *" AND "Terminology"') |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-06-19 : 09:12:23
|
You can only have your wildcard at the end: '"Reference*" AND "Terminology"' to find 'Reference and Terminology'
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Contains()