That is a very common problem. Sometimes the view select statement is not defined properly or sometimes you do not have a value in a field that is supposed to be there, and you get the nasty NULL legend.
You can use the NVL function thus: select NVL(customer.name,"") as customername, etc This function replaces the value not found with whatever you send it as the second parameter. This parameter has to be of the same type as the missing value, ie, character, logic, number, date, etc Rafael Copquin ----- Original Message ----- From: John J. Mihaljevic To: [EMAIL PROTECTED] Sent: Wednesday, March 21, 2007 11:56 AM Subject: Preventing .null. Values in a view Hi all, 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. Thanks, John "The difference between a successful person and others is not a lack of strength, not a lack of knowledge, but lack of will." - Vince Lombardi * All mail scanned by Norton AntiVirus. No AV software on your computer? Remove me from your address book, please. * Please respect my privacy. Do not forward my address to anyone else or include me in emails sent to multiple recipients. Use BCC. [excessive quoting removed by server] _______________________________________________ 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.
