Oracle NULL vs empty string

I'm pulling data from Oracle Spatial. I'm trying to define three label classes similar to the following:

- where some_column != "value"

- where some_column = "value" and other_column is null

- where some_column = "value" and other_column is not null

I've tried setting up the second clause of the last two classes using !=  and =, leaving the Value column blank in both cases. The != version shows up as expected, but the = version doesn't.

As a work around, I tried leaving out the conditions on the third class assuming that only one label style could be applied to each feature. This doesn't seem to be the case- my 'default' labels were shown on top of the other label classes that matched.

Any way to make this work?

 

--

Microstation: 08.11.07.443

Map: 08.11.07.425

 

Parents Reply Children
No Data