hi try this logic but in sal columns null values not retriveing

select *

from aaaa

where RTRIM(ISNULL(id, '')) = '' or

RTRIM(ISNULL(name, '')) = '' OR RTRIM(ISNULL(sal, '')) = ''

that records is 4loNULL

and plz exp how that logic RTRIM(ISNULL(id, '')) = '' how its checking.

plz tell me