>Please advise how, in an SQL Select statement I can 'create' an empty logical field. I know SPACE(6) as xyz will give me a field called xyz which is 6 characters wide. etc. I just can't think how to do the same with a logical field..
>
>Thanks!
use CAST(0 AS BIT) as xyz
[Update]
Oops, sorry, I just saw you are using VFP not SQL...
SELECT .f. as xyz will work
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges