returns, as the msdn suggests it should the ENTIRE table. Or does it? With Oracle we have been using this instruction and it doesn't return the data for the entire table - in fact I don't think it returns very much at all. Is there a parameter we are missing on our connection string? Cheers Antoine