I have tracked down the problem (but not the solution), it would appear that
the data type 'text' is causing the problems. If a column of type text is
included in the query then only one row is returned, else all rows are.
Why is this, is it the ODBC driver or NT Server 4 or something else?
Thanks in advance.
Graham.