>I am using a special Foxpro com object to execute my commands. Since I need some special data types in Fox, we had to do this. I can pass in parameters if I create a method on my com object and recompile it, but was trying to avoid it for this single purpose.

Oh, sorry Tim ... I just assumed you were passing stuff to the VFP OleDb provider directly in your app, not going to a VFP COM object. Yeah, horse of a different color ... <g>

~~Bonnie