On 20/05/2014 11:39, Khangelani Gama wrote:
> Sorry
>
> I found the problem, it’s data problem in another database, it’s trying
> to convert numeric null but of which it’s not a null data, it’s a blank
> data.
Hi there,
I'm glad you were able to find the solution to your problem. I have to
say, though, that I found that monster of a query which you posted
completely unreadable.... maybe it's just me, but it scared me off even
attempting to help you! :-)
Some basic formatting on the query - indentation and what not - would
have made it much less impenetrable, and people might have some chance
of being able to help.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie