Hi Jeff,

Yes in hindsight I should have shown the exact select statement which would have shown the cast as part of the join. I guess I was thrown by the...

Hi Jeff,

Thanks for your reply and I now see the typo in the table alias.... duh!

As it happens, I think we have just figured out the issue which seems to...

Thanks for the suggestion Steve but no joy I'm afraid, still the same error..

Cheers,

~Shaunos