joefawcet was helping me out on this (I have all of 5 hours exp with SQL. I am a poor network Admin that got roped into solving this)

I am 80 percent there with a resolve. I am taking column 1 and column 2 in a table and having them shop up in a added column 4 to look like this

000987.88890


newColumn AS col1 + '.' + col2
 (thanks Joe)

while this does work for what I want, I cannot figure out why some cells show correctly as 000987.88890 and other have a large space in them like "000987 .88890"

is this a problem with the way the data was input?

should I move to a direction of creating a "view"?

newColumn AS ltrim(rtrim(col1)) + '.' + ltrim(rtrim(col2))