Hi Jeff:

I worked around this problem in a fairly convoluted way because of the particular situation in this instance. I could obviously let you have details if you require them. However, probably the simplest way to do this is just create a dummy, empty table (no rows) with a single column defined as an integer. On the side where you need an integer placeholder, do as follows :-

...
UNION ;
SELECT Field1.Table1, Field2.Table2, FakeInt.iIntCol ;
...
FROM Table1, Table2, FakeInt ;
WHERE Table2.KeyField = Table1.KeyField ;
...

You don't need to specify a join condition on the FakeInt table.

HTH.

>Hi Gary,
>
>Unfortunately I have the same issue and have not been able to resolve it either. The INT() function does not work, but beyond that I have not attempted a bunch of workaround gymnastics. My app works fine with either a numeric or integer.
>
>But, I would very much like to be able to force an integer constant as a placeholder to be used when an integer only appears on one side of a union.
>
>Jeff