>>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/
>
>You're missing ) after replicate. See correction inline.

Actually I figured it out after I posted. This is what I got:

SELECT	PartId, 
		PartNo + REPLICATE(' ', 20) + RIGHT(CAST(Description AS VARCHAR(100)), 100) PartInfo
	FROM Parts
	ORDER BY PartInfo

Thanks