Yes, the stupid NULL predicate

But maybe a clever getaround?

Hopefully the short circuit will pick up the first condition (@name = 'nothing') without calling CONTAINS

You never know with SQL full-text functions 😛

IF @name IS NULL

SET @name = 'nothing'

select *

from table

where country in (@countryparameter)

and customertype in (@customertypeparameter)

and (@name = 'nothing' OR contains(name,@name))