How to check for isnull or empty? I'm trying to check as below but its not returning expected results.
AND (CS.StudentName like '%'+ISNULL(@StudentName,CS.StudentName)+'%')
AND (Cl.Street like '%'+ISNULL(@StreetAddress,Cl.Street)+'%')
The above statements are ignoring the rows if the column has explicit NULL value.
Thanks in advance.