-----Original Message----- From: Lloyd Thomas [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 25, 2006 7:49 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Re: number problem with 3.2.8
I did try number literal >10 but mad no difference. I will rebuild the database row as an integer. Lloyd ------------------- Or, if you have some reason for preferring varchar, you can choose to force a numeric comparison at query time by adding "+0" as in: select ring_time from calls where ring_time+0 > 10; ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------