Subject RE: [firebird-support] Re: CHECK for all numeric characters
Author Rick Debay
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

> 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