Full text catalog/index search for %book%

by

unfortunately CONTAINS only supports prefix wildcards:

CONTAINS(*, '"book*"')

More Related Contents:

  1. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  2. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  3. Parameter Sniffing (or Spoofing) in SQL Server
  4. What are the main performance differences between varchar and nvarchar SQL Server data types?
  5. SQL Server String or binary data would be truncated
  6. Datatype for storing ip address in SQL Server
  7. How to change identity column values programmatically?
  8. best way to convert and validate a date string
  9. Why use the INCLUDE clause when creating an index?
  10. Why is it considered bad practice to use cursors in SQL Server?
  11. Is it possible to use Full Text Search (FTS) with LINQ?
  12. SQL Server pivot vs. multiple join
  13. SQL Query to find the last day of the month
  14. SQL Server, convert a named instance to default instance?
  15. How do you specify a different port number in SQL Management Studio?
  16. WHERE clause on SQL Server “Text” data type
  17. Aggregate bitwise-OR in a subquery
  18. Check if a temporary table exists and delete if it exists before creating a temporary table
  19. Parse XML in SQL Server
  20. Drop primary key using script in SQL Server database [duplicate]
  21. How to create the linked server for SQL Server 2008 where we have the database from 2000 and 2005
  22. Decimal values in SQL for dividing results
  23. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  24. How to store directory / hierarchy / tree structure in the database?
  25. INFORMATION_SCHEMA vs sysobjects
  26. Bulk insert fixed width fields
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. “Prevent saving changes that require the table to be re-created” negative effects
  29. Convert UTC Milliseconds to DATETIME in SQL server
  30. Table Valued Function Killing My Query Performance

Leave a Comment