Subject | RE: [firebird-support] Re: CHECK for all numeric characters |
---|---|
Author | Rick Debay |
Post date | 2005-09-02T16:21:09Z |
This works:
CAST ('1' || VALUE AS NUMERIC(11,0)) BETWEEN 100000000000 AND
199999999999
AND VALUE NOT CONTAINING 'e'
AND VALUE NOT CONTAINING ','
AND VALUE NOT CONTAINING '.'
Now I'm testing to see which CONTAINING tests I can remove.
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: Friday, September 02, 2005 11:23 AM
To: Firebird-Support
Subject: Re: [firebird-support] Re: CHECK for all numeric characters
have no idea how it could happen, since I copy/pasted it from isql), so
I will try again:
CHECK ( CAST ('1' || Value AS BIGINT) BETWEEN 100000000000 AND
199999999999
AND Value NOT CONTAINING 'e')
Ivan
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet
Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
--------------------------------------------------------------------~->
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
CAST ('1' || VALUE AS NUMERIC(11,0)) BETWEEN 100000000000 AND
199999999999
AND VALUE NOT CONTAINING 'e'
AND VALUE NOT CONTAINING ','
AND VALUE NOT CONTAINING '.'
Now I'm testing to see which CONTAINING tests I can remove.
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: Friday, September 02, 2005 11:23 AM
To: Firebird-Support
Subject: Re: [firebird-support] Re: CHECK for all numeric characters
> You are also correct. Perhaps I should cast it as NUMERIC(11,0).Now I see the solution I sent yesterday arrived distorted somehow (I
have no idea how it could happen, since I copy/pasted it from isql), so
I will try again:
CHECK ( CAST ('1' || Value AS BIGINT) BETWEEN 100000000000 AND
199999999999
AND Value NOT CONTAINING 'e')
Ivan
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet
Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
--------------------------------------------------------------------~->
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links