It would be nice if the SQL SELECT syntax included some sort of schema directives, but unfortunately it does not. I'm using local views and haven't been able to force calculated columns resulting in integer values to be of type INTEGER.

Thanks anyway,
Jeff