Search for “whole word match” with SQL Server LIKE pattern

by

Full text indexes is the answer.

The poor cousin alternative is

'.' + column + '.' LIKE '%[^a-z]pit[^a-z]%'

FYI unless you are using _CS collation, there is no need for a-zA-Z

More Related Contents:

  1. SQL QUERY COUNT THEN ADD
  2. SQL server command help and tutorials for specific commands?
  3. How do I UPDATE from a SELECT in SQL Server?
  4. How to calculate age (in years) based on Date of Birth and getDate()
  5. CROSS JOIN vs INNER JOIN in SQL
  6. INNER JOIN vs LEFT JOIN performance in SQL Server
  7. Function vs. Stored Procedure in SQL Server
  8. How to get difference between two rows for a column field?
  9. Counting DISTINCT over multiple columns
  10. SQL Server SELECT into existing table
  11. How to check if a stored procedure exists before creating it
  12. Insert Into… Merge… Select (SQL Server)
  13. The parameterized query expects the parameter which was not supplied
  14. SQL Server: drop table cascade equivalent?
  15. SQL Server converting varbinary to string
  16. Must declare the scalar variable
  17. Why does SQL Server round off results of dividing two integers?
  18. How to Map Input and Output Columns dynamically in SSIS?
  19. Find the real column name of an alias used in a view?
  20. How to get the identity of an inserted row?
  21. Insert Update stored proc on SQL Server
  22. SQL Server: should I use information_schema tables over sys tables?
  23. TSQL – How to use GO inside of a BEGIN .. END block?
  24. Finding a Top Level Parent in SQL
  25. SQL Server Cumulative Sum by Group
  26. SQL Server FOR XML Path make repeating nodes
  27. How do I change db schema to dbo
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. How to get the next number in a sequence
  30. How to insert into a table with just one IDENTITY column?

Leave a Comment