It should look something like this:
create sql view blabla as select x,y, padl( allt(dashno),10 ) as dashjustified, etc... from .... order by 3
In the order by just put the field position in the select ( 3 in the example ).
You can also transform it to numeric instead ( use VAL() function )
Cheers,
Jaime
>Jaime,
>
>It is a charactor. How can I justify this feild in the View Designer?
Why do programs stop working correctly as soon as you leave the Fox?