>Chung,
>
>I think you need the DBSETPROP command. You set the 'Field' properties and many other types of DB properties with that command. You define it outright N(14,4) right in code.
>
>To learn how to use that code you download eView tool from the download section. eView is a great tool made by a guy who lives in Texas. With that tool you can generate code that creates and defines the view. Then you look at that code and learn to work with it.
>
>Wally

Thanks, I will take a look. However, is there anyway I can use the database designer to do it - i mean "visually". I have many views out there and the application is already distributed, if not necessary, I don't want to add additional piece of code to just redefine all the views.
TIA