I am having a problem running a stored procedure using isql to launch the procedure.

My stored procedure contains a statement like:

select @myvar = count(*) from mytable where mycolumn is null

when I run the procedure from query analyser a value is set in @myvar showing the correct number of null values from mytable which is output to another table where I can see it.

Without making any changes, when I run the identical procedure using isql to execute the procedure @myvar gets set to zero. The procedure cannot find the null values in mytable

I have tried setting ANSI_NULLS on and off inside the procedure but still get the same result.

Can someone please tell me what is going on, and how I might get isql to show me how many null values exist in the table?

Sorry, I put this question in the wrong thread I meant mssql, not mysql. Can an administrator please delete.