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.

TIA,

Alex