1、根据标量函数求 select [id] from table where isnull(Name,'')='' 2、 select [id] from table where [Name] is null