Show if NOT NULL is not working for me.

Can you please advise as how to write a show if rule for null.
I tried !-""
!=''
!=NULL
!+'(NULL)'

I checked and the value in my database field is (Null)

It appears my default options are NULL or empty string.
This is a decimal colum with 2 decimals. Which do you recomend NULL or empty string as default?

Thank you

empty() will catch both. If you post the full line of code then I could show you in context.

Ok great. Pasted in PM - Thank you!

<?php
if (($WADAstats_barrel_races->getColumnVal("earnings_breeder")) > "0") { // WebAssist Show If
?>
<span class="breeder"> $<?php echo ($WADAstats_barrel_races->getColumnVal("earnings_breeder")); ?></span>
<?php
}
?>

You can probably just use:

<?php
if ($WADAstats_barrel_races->getColumnVal("earnings_breeder")) { // WebAssist Show If
?>
<span class="breeder"> $<?php echo ($WADAstats_barrel_races->getColumnVal("earnings_breeder")); ?></span>
<?php
}
?>

Thank you!
That worked for decimal columns. Is it not working for var char columns. I am pasting those in PM.

All the columns are NULL be default. Is there a better option for the default since that seems to be my problem.
What is the advantage or NULL verses EMPTY STRING?

I guess I am asking: when should NULL be used as default and when should EMPTY STRING be used?

They function similarly. I guess using empty string does keep things less complicated, but accounting for NULL isn't too difficult.

OK, thanks. I guess we will work on those show if rules that varchar and are not working in a private session? (#5 posted 9:39am on this ticket)

if (($WADAstats_barrel_races->getColumnVal("sire")) != "") { // WebAssist Show If

becomes:

if (($WADAstats_barrel_races->getColumnVal("sire"))) { // WebAssist Show If

Thank you but that did not work for me. I verified the record is showing a NULL value in the database.
I copied exactly what I tried.