PartInfo = CAST(PartNo AS char(20)) + Description

>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/