>I have a grid based in a sql statement with an outer join. Fields with NULL values show the word .NULL. when not having a value. The NullDisplay property only works when that field has the focus. How can get a blank field in the whole grid instead of showing it only when the field has the focus?
>Please be as specific as possible.
>Thank you in advance.
>
>Ulises.
When doing a SQL Select, I prefer to use the NVL() function to convert nulls in the result to what I want displayed.