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?