Hi,
I have a simple query in a stored procedure that have something like "WHERE Col1 IS NOT NULL". The query run correctly when SET ANSINULL OFF but not working when SET ANSINULL ON. (IS NULL work correctly in two situation.)
below is my code
I'm using Sybase 11.0 running in Sun...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.