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/
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people