I am using Oracle Version 11G 18.104.22.168.0 64 bit. We have several views with fields that are returning nulls. However crystal reports is reading the report of <null> in the data set and printing that into the PDF report. So I tried to use the NVL function that had worked so well in replacing null values in numeric fields with 0's. i tried to substitue in empty strings. However the result was not satisfactory. About 2/3 of the nulls were still showing up in the result set, whereas about 1/3 had been replaced with a blank. I tried Coalesce but kept getting data type mismatch errors. Then I tried using NVL and replacing the Null with a space. Last night that worked great. Then today I was given a couple of other views on which to make this change. And surprise surprise, the NVL funtion had gone back to showing 2/3 of the nulls as nulls. I tried Coalesce, and this time converted the space literal to an NVARCHAR. No more datatype mismatch. However still about 2/3 of the nulls were still being shown as "<null>". I have no idea why this function is not working as reported in the documentation. Any help would be appreciated as this project is overdue and I am going to have my head handed to me on a platter, in an economy with 10% unemployment.