COALESCE(filter, '%')

(
    Table.Column LIKE @myParameter
OR
    @myParameter IS NULL
)

ISNULL(Table.Column, @myParameter) = @myParameter

SELECT
 lalala
 WHERE 1=1
 and (
  value like '%'+@search+'%'
  or @search = ''
 )