The error msg just said " sql server does not exist or excess denied"

But them I fixed my problem by reinstall the sql express again( somehow it asked me to...

Thanks a lot. It worked just the way I wanted.

Hi all,

I did a couple test as steve suggested. it turned out no matter mychar is varchar or char,  the '' and '  ' are treated as same. I guess I...

Hi all,

I did a couple test as steve suggested. it turned out no matter mychar is varchar or char,  the '' and '  ' are treated as same. I guess I...

I guess I should reword my question. I know that '' and '  ' are both valid values and I am not comparing them with NULL. I am trying to...

Thanks for all the response. I tried Eric's method and combined with other checking in the beginning of the delete. It is working now.

 750000 rows. This delete is the beginning of a application event. I want to be able to delete the rows by a passed in parameter . That is why I can't...