I am trying to access a field in a SQLServer database that is of type "L".

The field's name is OPEN. If I read the table using * to select all records, I have no problems; the field in the cursor shows up as logical.

However, if I try to list the field name explicitly in my list of fields ("Select TransferNumber, open") or use it in a WHERE clause ("Select * Where OPEN"), I get an error code back.

Suggestions?

Thanks,

Jim