The database is DB2 on an AS/400 and it has a smallint (-32,000 to 32,000 range Integer) but no BIT or Logical type.


>
>I am working on a conversion to a backend database where I have to store 0/1 to represent .F./.T.
>
>
>Stored field data type ?
>If MS SQL -> use BIT data type
>
>Backend Name ?
>
>If MS SQL
>in SELECT command use
>CONVERT(BIT,Backendfield)
>or
>CAST Backendfield AS BIT