See the corrections in bold below. The size of every field in SQL Select is determined by the first record. When table is empty the priority filed will have value "LOW" - 3 characters otherwise it could be "HIGH" - 4, or "NORMAL" - 6.
>
>I am sending sql statement which I copied from view designer. Will you need the structure of tables?
>
>* This is the same view as vwmails, but only contains displayed field for sorting

>SELECT Mails.mailkey, .F. AS sel, Mails.readmail, Catmst.cat_name,;
>  <b>PADR(IIF(Mails.imp=1,"HIGH",IIF(Mails.imp=2,"NORMAL","LOW")), 6)</b> AS priority,;
>  Addbook.sender, Mails.subject, Mails.recvdt, Mails.docdt,;
>  Addbook.designation, Mails.action, Mails.proposalno, Mails.fileno,;
>  Mails.rcvlink, Mails.remark, Med04.language, Statumst.status,;
>  Mediumst.medium, Mails.user, Mails.maildate;
> FROM amw!mails, amw!addbook, amw!catmst, med04, amw!statumst, amw!mediumst;
> WHERE Catmst.cat_code = Mails.cat_code;
>   AND Addbook.sendercode = Mails.sendercode;
>   AND Med04.lang = Mails.lang;
>   AND Statumst.statuscode = Mails.statuscode;
>   AND Mediumst.mediumcode = Mails.mediumcode;
>   AND Mails.user = ?MUser;
> ORDER BY Mails.maildate DESC