>I want to select add a new column to a select statement. I want to create the column as a logical column in the result cursor. All of the fields actually do exist except for iflag:
>
>SELECT field1, field2, field3 as newfield, .F. as iflag
>
>I can do:
>
>SELECT field1, field2, field3 as newfield, 0 as iflag
>
>but I want a logical field not a numeric field. I've been racking my brain and I just can't remember what the syntax is!
>
>TIA,
>
>Tracy
SELECT field1, field2, field3 as newfield, CAST(0 as bit) as iflag
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.