You are absolutely right. I guess in my haste to get it working for positive integers only, I put the shrink wrapper on to soon.
Mike > -----Original Message----- > From: Wolfgang Rohdewald [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 14, 2005 8:39 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Convert and isnumeric function > > On Samstag 14 Mai 2005 00:31, Michael Evenson wrote: > > case SQLITE_TEXT: { > > const char *z = sqlite3_value_text(argv[0]); > > for (i = 0; i < strlen (z); i++) { > > if (!isdigit (z[i])) { > > nResult = 0; > > break; > > } > > this should return FALSE for -5, 1123.456. > In some locales, that might be written as 1'123,456 or > 1,123.456 or whatever. > > strtol() > > seems to what you need, see man strol() > > -- > Wolfgang >
