Skip to Content
0
Former Member
Dec 02, 2011 at 02:43 PM

Using "LIKE" operator

31 Views

Actually i wrote a formula (closed-school)as bellow

if {DOE_INSTITUTION.ADDRESS1} like "CLOSED"

or {DOE_INSTITUTION.ADDRESS2} like "CLOSED"

then

true

else

false

and using this formula in Record selection as bellow

and not {@closed-school}

Here my problem is, this one does not returning the record when there is no data in either of the fields(Address1 or Address2), like null in database, which i want to display even when it is null.

Please help me

Thanks,

Krish