12. Report-Writer Statements : Print Statements : .Nullstring Statement--Specify String for Null Value : Example
 
Share this page                  
Example
Suppose phone_number is a nullable integer column whose value is null. If you issued the following print statements:
.nullstring       'N/A'
.print      '     Phone number = ', phone_number .nl
.nullstr          '?'
.print            'Phone number = ', phone_number .nl
Report-Writer would print the following if the value of phone‑number were null:
Phone number = N/A
Phone number = ?