Have you tried using a derived column with the correct target data type as opposed to casting it in the SQL statement?
John Rowan
======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden