Hi!
Use NVL() function to replace null valies with characters.
To define view in code use:
CREATE SQL VIEW ViewName AS SqlSelectStatement

>How does one get around the limitations of the view designer? For example:
>
>I am defining a wiew that is a right join, but I want a character field to be character, not null, in the cursor when there was nothing there. Tried using an expression, but don't know how to give it a name. Ideally, I would like to just define the SQL and then define all the "extras" (defining updateable fields etc) graphically. Tried to hack the DBC... oops, it became unretrievably corrupted.