Null value issue

[raisa]

Hello everyone,

I try to get correct data in CR9, using simple SQl statment. But I am missing some records, I think it is because they may have 'null' value.
I have two fields:
math (value Y or NULL or N)
and
read (value Y or NULL or N),

I would like to see all records where math='Y' or read='Y'.

I am getting combination of Y Y or NULL Y or Y Y and I can not get combination of Y NULL. I tryed IsNull function and InStr, but seems it is doesn't change the result. What am I doing wrong?
Any help would be appreciated!
:wave:

[blanch1122]

Are you limiting the data through sql or through record selection in Crystal Reports?

[raisa]

Actually, I am suppose to do it through ASP pages, but doing so I am missing some records, so than I limited the data through the record selection in Crystal and I was getting the same result(..still missing records...) The same SELECT statement works fine in SQL...
:confused:

[ashu]

Dear Raisa,

ur query shd not be a proble.pls chk whether the parameters are taken carefully:i selection formula orRegards,


Ashwin

[raisa]

I think I got it! I use IsNull and InStr functions, checking for NULL and "" values.

Thanks for help!
:p