Alejandro,
In addition to the answers you've received, you can enter an expression into VFP's view designer:
*-- enter the following into the Functions and Expressions textbox:
NVL(FieldName, '') AS FieldName
HTH
>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
Daniel