***是 ISNULL，即:

The best would be ISNULL, i.e.:

DECLARE @searchstring varchar(500)
...
IF(ISNULL(@searchstring,'') = '')
    EXEC(@strexecsql)
ELSE
    EXEC(@strexecsql1)