Thanks everyone for the feedback. Sometimes you just make things difficult on yourself which is what happened in this case. I simply changed the datatype in the table...
Thanks, that solved my problem. I actually have some internal data issues that were causing there to be NULL values when there should not be. Problem solved.