We are trying to use the following line, okay well while debugging we took it down to the following line, in hopes of solving the problem, but thus far havent.
SELECT ATC(' ',misc.desc),LEFT(misc.desc,ATC(' ',misc.desc)) FROM misc
The first ATC() returns the correct Position of the space from...