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/