>>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/>
>In your case as Sergey pointed out you simply need to cast PartNo to the CHAR of the appropriate length.
Right. I had to cast Description also because it's Text.
Thanks everyone.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people