RIGHT is missing it second parameter and a closing parenthesis.

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