You appear to have ANSI_NULLS set OFF (rather than the default ON). Your
query will only return "1" if ANSI_NULLS is set OFF. SPs store the state of
the ANSI_NULLS setting at the time they are created so your SP must have
been created with the setting ON which explains why it gives the expected
result: an empty result set.
Either re-create the SP or change ANSI_NULLS to ON in Query yser.
Please reply only to the newsgroup