You are also correct. Perhaps I should cast it as NUMERIC(11,0).

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ivan Prenosil
Sent: Friday, September 02, 2005 11:01 AM
To: Firebird-Support
Subject: Re: [firebird-support] Re: CHECK for all numeric characters

> CAST(VALUE AS BIGINT) BETWEEN 0 AND 99999999999
>
> Worked great, thanks.

But it does not meet specification from subject line, i.e. "CHECK for
all numeric characters", since it also allow spaces, (decimal) point,
plus/minus signs, letter E (for exponent).

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