>So is there a better way to trim leading spaces off of a numberic value?

Leading spaces are only a display concern. If what you want is a string representation of a numeric value, then you can use ALLTRIM(STR(nValue)) or even TRANSFORM(nValue).