I created FULL TEXT Catalog on SQL Server 2000 database.
I am trying to search records on several tables.
I have this textbox on asp.net page (NET 2.0).
I have a sql string of "select xx,xxx from table1 where contains(columnName, '" + textbox1.text + "')";
This is giving out exception.
I tried with one with TextBox1.Text.Trim() but still same error.
1) Do you know what I did wrong here??
2) About the Full Text Search, do you know if it is searching the whole search or search each of the tokenized words??