Is it possible to do a SELECT AS FIELDNAME1,FIELDNAME2, LCHECKED AS .F. in some way? I have specifically tried this, but it doesn't work as I have done it. Is there another way to do this so that you can create a new LOGICAL field in a new TABLE created by the SQL statement?