>>>>Does anyone know if you can assign alias field names when creating local views with the View Wizard?
>>>>
>>>>In the field selection tab I'd like to select field x AS y for the View output, but don't see any way to do it.
>>>>
>>>>Thanks!
>>>>
>>>>Mandy
>>>
>>>You can modify the view you created with View Wizard, and use Fields/Expressions option to add something like "field1+field2 As Newfield" into View definition. BTW, it works better if you create a view programmatically.
>>
>>Edward,
>>I tried using the expression and it worked. Thanks.
>>
>>I'm just curious, if I created the view with the View Wizard initially, can I modify the code (programmatically) afterwards? I tried MODI VIEW Myview, but only got the Wizard back.
>>
>>Thanks again,
>>Mandy
>
>Probably not, at least I couldn't do it right now with 3b. However, you can create/delete view on fly using CREATE SQL VIEW, DELETE VIEW.

Thanks. I'll consider doing this for future views now that I've got a handle on what they're all about. Sounds like the easier way once you understand the language.