Your technology certification is waiting. Enroll in Cloud Class ®
'LIKE ''%'' '
DECLARE @sql NVARCHAR(max)
DECLARE @yoursearchstring NVARCHAR(max)
SET @yoursearchstring = 'test' --change it to your search string, or make it a parameter
SET @sql = 'SELECT * FROM [yourtablename] WHERE 1=1 '
IF @yoursearchstring != ''
SET @sql = @sql + ' AND [yourcolumn] LIKE ''%' + @yoursearchstring + '%'' '
exec sp_executesql @sql
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.