Home Forums SQL Server 2005 T-SQL (SS2K5) n.value = isNull(@Value,n.Value) Different Record Counts Returned. RE: n.value = isNull(@Value,n.Value) Different Record Counts Returned.
Timothy J Hartford
SSCarpal Tunnel
Points: 4214
More actions
December 8, 2009 at 9:52 am
#1089344
Just a thought, but NULL != NULL (unless ANSI_NULLS setting is OFF), therefore if the value in the column is null, this would return false.