Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Jun 26th, 2012  |  syntax: None  |  size: 0.63 KB  |  hits: 12  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. How to use LIKE in a t-sql dynamic statement in a stored procedure?
  2. SET @SQLQuery = 'SELECT * FROM [tblApps] WHERE [firstName] LIKE %@search%'
  3.        
  4. SET @search = '%' + @search + '%'
  5. SET @SQLQuery = 'SELECT * FROM [tblApps] WHERE [firstName] LIKE @search'
  6.        
  7. SET @SQLQuery = 'SELECT * FROM [tblApps] WHERE [firstName] LIKE ''%' + @search + '%'''
  8.        
  9. SET @SQLQuery = 'SELECT * from [tblApps] WHERE [firstName] LIKE ''%'' + @search + ''%'''
  10. exec sp_executesql @query=@SQLQuery, @params=N'@search nvarchar(96)', @search=@search
  11.        
  12. SET @search = '%' + @search
  13. SET @SQLQuery = 'SELECT * FROM [tblApps] WHERE [firstName] LIKE ' + @search + '%'
create a new version of this paste RAW Paste Data