Replace NULL with substitute text

Toad Data Point
1

Does anyone know how to replace DB NULL values with text in a report? Right now if the field is NULL the label is just blank. Thank you in advance for your reply.

Toad for Data Analysts ver. 2.7.0.348

2

How about handling this in SQL? Most languages have a NVL function.

Debbie

3

Thank you for the reply. I ended up adding a calculated field with the following formula.

Iif(IsNullOrEmpty([FIELD1]),‘Null’,[FIELD1]).

Although, I would say the NVL way is much easier and a better solution.