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