>I'm trying to pull two columns with some space between:
>
>

>
>	SELECT	PartId, 
>			PartInfo = PartNo + RIGHT(REPLICATE(' ', 20) + Description
>		FROM Parts
>		ORDER BY PartInfo
>

>
>I'm getting 'Incorrect syntax near the keyword 'FROM'.'
>
>I got this example from http://www.sqlusa.com/bestpractices2005/padleadingzeros/

In your case as Sergey pointed out you simply need to cast PartNo to the CHAR of the appropriate length.