We're in the process right now of switching over our servers that run our reports to SQL Server. We're testing all the reports before we put them live just to make sure that we're getting all the data converted properly.

Well we've run into our first snag of the process.

In my NOTATION table under the field of NOTE it's not converting over nicely. As in, some of it converts nicely the rest of it converts to something like this:

"134KH1LKJ34H1L3JK41324090490813247013HV1J4H34H12L 34Y1032471083"

I've tried converting it over but I've had no luck...if anyone has any suggestions I'm open to trying anything.

Thanks in advance