Re: How I can select where a date is null..

"Ms. D.H. Harvey" :
> When correct typo in WHERE ( upper("tab1".field1") like :var1) AND
> returns row where field1 is 'A' for me. However, if I set var1 to
> 'A%' and var2 to 'B%' nothing is returned. This is to be expected.
> Field1 cannot be like both var1 AND var2. If you really meant to
> compare field1 to var2 then change the AND to OR. Could it be a
> typo? Did you mean to compare field2 to var2!

Hi Helen, my problem isn't the where condition for field1 and field2. My problem is having a correct result when I check a date field that contains null value.
I must compose a query research, and the user can insert or not one or all of these 10 fields.
If the user insert 'A%' in the field1, I want to see all rows where field1 begin with 'A' also if another fieldx of the same row contains null value.

Bye
Paola Received on Tue Apr 20 2004 - 02:01:01 CDT