SQL话语判断字段是否为空

SQL语句判断字段是否为空

select *? from LAWPEOPLE where retirement? is null and name='康小国';

查询有结果

select *? from LAWPEOPLE where retirement? =null and name='康小国';

查询无结果