"Jeff Godfrey" <[EMAIL PROTECTED]> wrote: > 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? >
I'm not sure what "int()" does. Maybe you are looking for round(). Or perhaps cast(expr AS int) will serve your needs. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------