Toad World® Forums

Replace NULL with substitute text

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

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

Debbie

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.