Mark,

You can use CAST() or CONVERT function.

CAST( LEFT(RTRIM(sect_desc),25)+" / "+
  LEFT(RTRIM(head_desc),20)+" / "+
  LEFT(RTRIM(item_desc),20) AS char(80))as Myfield

>When creating a view in Sql Server how do I ensure the length of a field returned is kept to a specific zize
>
>In Visual Foxpro I would do this
>SELECT PADR(LEFT(ALLTRIM(sect_desc),25)+" / "+LEFT(ALLTRIM(head_desc),20)+" / "+LEFT(ALLTRIM(item_desc),20)as Myfield
>
>
>But I can not find the equivelant of the PADR() command.