Can you find the record in your remote table and examine the data via Query Analyzer?
>Sometimes I receive strange characters among data I've just retrieved in a sql remote view. The DBMS is SQL MSDE. In that particular case, sometimes (just a few times) a numeric field in my view is "invaded" by a alpha charater (a suplementary character). For instance, if the number is $ 1.234,00 it sometimes comes like 1O.234,00 (it is an "O" characeter, not a zero).
>
>Could anyone help me to understand what is causing this strange behavior ?
>
>Thanks
>Dany Wulkan
Peter Pirker
Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?
(Woody Allen)