>
>01) I advise developer to use NULL insteads of '' and use default as NULL
>for the parameter, is that right ?
Yes, make default Null and advise developer not to pass parameter at all or pass as Null, if he has to.
>
>02) On the other hand, why is the SP code, if (LEN(@para1) > 0) become true
>when @para1 = '' ?. Why ? Currently, i am using if(len(@para1) > 2) to check
>for any parameter pass in and if(len(@para1) = 2) to check for empty parameter as changes to my system now is too big a impact.
Maybe it has some binary character in it that looks like space but isn't? What's database compatibility level?
--sb--