How do you get leading wildcard full-text searches to work in SQL Server?

by

Workaround only for leading wildcard:

  • store the text reversed in a different field (or in materialised view)
  • create a full text index on this column

  • find the reversed text with an *

    SELECT * 
FROM TABLENAME 
WHERE CONTAINS(TextColumnREV, '"mrethcraes*"');

Of course there are many drawbacks, just for quick workaround…

Not to mention CONTAINSTABLE…

More Related Contents:

  1. Is it possible to use Full Text Search (FTS) with LINQ?
  2. Full text search does not work if stop word is included even though stop word list is empty
  3. SQL Server Full Text Search Escape Characters?
  4. 7645 Null or empty full-text predicate
  5. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  6. Full text catalog/index search for %book%
  7. Updating image in VB and SQL Server not working [closed]
  8. Where clause not working in sql server
  9. Compare the values of column in SQL Server
  10. T-SQL stored procedure that accepts multiple Id values
  11. LocalDB deployment on client PC
  12. How do I escape a percentage sign in T-SQL?
  13. Using RegEx in SQL Server
  14. What is the best way to auto-generate INSERT statements for a SQL Server table?
  15. Get list of databases from SQL Server
  16. SqlServer: Login failed for user
  17. SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
  18. SQL Update with row_number()
  19. EXEC sp_executesql with multiple parameters
  20. SQL Server – Dynamic PIVOT Table – SQL Injection
  21. Difference between #temptable and ##TempTable?
  22. How to add custom attributes to SQL connection string?
  23. SSIS reading LF as terminator when its set as CRLF
  24. What are some ways of accessing Microsoft SQL Server from Linux?
  25. Compute MD5 hash of a UTF8 string
  26. Sort Bullets in Database
  27. How do I remove non-breaking spaces from a column in SQL server?
  28. Why is casting from float to varchar being rounded in SQL Server?
  29. Conditional JOIN Statement SQL Server
  30. Oracle sequence but then in MS SQL Server

Leave a Comment