> I created a view in which some fields are giving me a null value. For > example, if customernumber 100 isn't found, customername is ".NULL." instead > of giving me an actual customer's name from my Customers table. > > This is correct, but is there a way to have this field show me blanks > instead of ".NULL."? The reason I ask is for printing the report. I'd > rather the report be blank in these cases instead of printing .NULL.
If it's just a display issue, execute this before running your report: SET NULLDISPLAY TO "" Or in the SQL, you can wrap the fields that might be null with NVL(Table.Fieldname, ""), which will actually make it a blank string in the field. -- Derek _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
