if i do:

Code:
mycolumn LIKE ISNULL('%'+@Param+'%', mycolumn)
when @Param is set to null is '%'+@Param+'%' still null and therefore the mycolumn is set to equal itself? Or does the second part never run because the first always has a value?

cheers