Hi,

My two pennys worth

I personally think the stored procedure should return the data in the required format for the code. We have lots of code of the type:

if isnull(rs("Field1")) then

 strValue = ""

else

 strValue = rs("Field1")

end if

Which can be replaced in the stored procedure by

coalesce(Field1, '') as Field1

One has lots of lines of code, the other doesn't, so for our way of working, it is a bit of a no brainer.

As for replacing nulls in update procedures, I can think of as many arguments for as I can against. So no pointers there then.

Cheers!