I've noticed that if I use a * to select all the fields from a MS SQL 2000
Server table the values return, except for values contained in a TEXT or
NTEXT field, which I guess is the equivalent of a MEMO field in Access.

To get those fields to appear I have to select all the fields individually
AND they have to be listed in the order that they appear on the page...is
that normal or is something weird going on?

When we get a chance, we will be creating Stored Procedures for all of our
pages.

Thanks!

Mitch

I've never had that problem. Then again I do not use text datatype. char allows up to 8000 characters.

I don't think the problem is sql-related. It should be easy to work around