ok when i run the query thru .net it works fine. Thanks for the help people!