January 14, 2011 at 9:37 am
What is the difference between:
IsNull(field)
and
IsNull(Field,0)
Thank You
January 14, 2011 at 9:55 am
The first is used by SSIS to do a NULL test, ie: ISNULL(Field) returns true or false. The second is SQL saying that is the value is NULL then replace it with the second argument. There is also a .IsNull in relation to the geography datatype.
Clear?
CEWII
January 14, 2011 at 10:09 am
Ah...thanks!
January 14, 2011 at 10:35 am
You are welcome.
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply