When doing reports in Kentico, it is sometimes worth checking the out of the box reports, you might find a similar scenario.
E.g. The report under
Page reports ->
Content inventory report uses the following like condition:
WHERE (@name IS NULL OR DocumentName LIKE '%'+@name+'%')
Does this work for you?