>All,
>
>I need to have a calcuated field in s SQL JOIN with an integer field. I have tried an Int(1) as fieldname, but the field is a Numeric type.
>
>How can I get a field to be of type Integer?
>
>TIA
>
>Rex

You could also Select Into DBF and then use Alter Table - Alter Column. Although it requires an extra step.