How do I input a blank but not NULL value into a varchar parameter during
sproc debugging?

It seems that no matter I typed ('') / '' or leave it blank. It still not a
value that I wanted for the params.

LeonardP

Have you tried initializing the parameter to '' when it is declared? If no
value is provided, it uses the '' for it's value.
Ex: @P1 varchar(10) = '', @P2 varchar(5), etc...

"Leonard Poon" <leonardpoon (AT) hotmail (DOT) com> wrote