Using variable in SQL LIKE statement

by

If you are using a Stored Procedure:

ALTER PROCEDURE <Name>
(
    @PartialName VARCHAR(50) = NULL
)

SELECT Name 
    FROM <table>
    WHERE Name LIKE '%' + @PartialName + '%'

More Related Contents:

  1. How can foreign key constraints be temporarily disabled using T-SQL?
  2. What do Clustered and Non-Clustered index actually mean?
  3. Regex pattern inside SQL Replace function?
  4. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  5. How to create materialized views in SQL Server?
  6. How can I clear the SQL Server query cache?
  7. SQL Server Random Sort
  8. SQL Server database backup restore on lower version
  9. Add a new table column to specific ordinal position in Microsoft SQL Server
  10. How to update large table with millions of rows in SQL Server?
  11. Is there a way to simplify a NULL compare of 2 values
  12. How do you specify a different port number in SQL Management Studio?
  13. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  14. Sequence as default value for a column
  15. How to set monday as first day of week in SQL Server
  16. How do I flush the PRINT buffer in TSQL?
  17. SQL Server Login error: Login failed for user ‘NT AUTHORITY\SYSTEM’
  18. VarBinary vs Image SQL Server Data Type to Store Binary Data?
  19. Drop primary key using script in SQL Server database [duplicate]
  20. OR Operator Short-circuit in SQL Server
  21. How to store directory / hierarchy / tree structure in the database?
  22. Which is quicker COALESCE OR ISNULL?
  23. Merge multiple rows into a single row
  24. Generate table relationship diagram from existing schema (SQL Server) [closed]
  25. How does SQL Server decide format for implicit datetime conversion?
  26. Bootstrapping SQL Express from WiX?
  27. Error converting data types when importing from Excel to SQL Server 2008
  28. EAV over SQL Server
  29. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  30. The Best Way to shred XML data into SQL Server database columns

Leave a Comment