Since I've started using the other method, not binding params, I'de have to try to reimplement this method of running the sql query...I found the other way wasn't working becuase of some bad logic... so it's probably the same for this method....What I'll do is try this method again next time I run a query to see if it wasn't the logic that messed it up. Thanks for your help, I'm sure we had it right, lol