I'm currently converting some Access tables/views to SQLite. I've encountered some functions that apparently aren't supported by SQLite, so I've created my own (a power function and an "IIF" function). Also, several of my queries have a basic int() wrapper, that also seems to be unsupported. Like the others, I've just added my own, but I wonder if I'm missing something. The "expression" page doesn't seem to document an "int" function, but I wonder if there is some other equivalent?
Thanks, Jeff
