Are you using VFP, SQL Server, Oracle or some other database?

How is the value of the field being calculated? Calling a function? What is the return value of the function?

>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