"Jon Dixon" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Alternatively, enclosing the numbers in single quotes ( ... when '0' > then 'SUN' when '1' then 'MON' ...) will give you the expected > result.
If you want to go this way, be aware that %m specifier produces strings like '01', not '1'. Personally, I prefer converting to int, to stay independent from precise formatting details. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users