Cecil,

I know you've gotten good responses, but one question...do you always want it to be .F.? Does it depend on a value somewhere, or is it simply for use later? If it is dependent on a source value, try using IIF(fieldvalue = something, .T., .F.) AS lChecked

Dana

>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?