Jay,
I kindly beg to differ. I have a situation where a column can
contain either a name (like Joe Blow) or a numeric link to another name
(like 12345). If the column contains a numeric value then the link is
followed otherwise just the name is used. I would normally just handle it in
code, but I need to create a view that does a union with another table that
only allows numeric values in the same column. Hence I need the isnumeric to
eliminate the rows where the name is not numeric. I don't want them in the
view. I can probably get away without the convert funvtions. I'm going to
try that now. I compiled the isnumeric function into the sqlite3 code and it
works great.
Here's the view
create view CombinedLinksTo as
select nUID, nLinkedTo, cFullName, 'I' cType from WorldCheckData_LinksTo
union
select nUID, cCompany nLinkedTo, cFullName, 'E' cType from
WorldCheckData_Companies where isNumeric (cCompany) = 1 and cCompany != '.'
Mike
> -----Original Message-----
> From: Jay Sprenkle [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 13, 2005 3:47 PM
> To: [email protected]
> Subject: Re: [sqlite] Convert and isnumeric function
>
> > All or any,
> >
> > Has anyone implemented these as built in functions
> in sqlite
> > 3? If not - I was thinking of doing it and submitting to the
> > sqlite.org web site for submission.
>
> The api converts data types for you. Isnumeric might be
> useful but since the database isn't strongly typed it
> probably wouldn't get used much.
>
