Re: checking for numeric chars

[Alan Ljungberg <Alan.Ljungberg@CNPL.ENBRIDGE.COM>]

David.

Do you want to determine if only a single character is numeric then i would
evaluate if the ascii value is beween 048 and , 057.  048 and , 057 are the
ascii values for 0 and 9 , if the acsii value is any value between the
character is numeric.  This will work for numeric characters in CHAR
fields.

If your question is to deternime if a field type is numeric?  The best way
would be to query the system tables of your database.

-Alan.




                    David Thompson-Hall
                    <david.thompson-hall@DOIT        To:     
SQR-USERS@list.iex.net
                    .WISC.EDU>                       cc:
                    Sent by: "Discussion of          Subject:     checking for 
numeric chars
                    SQR, Brio Software's
                    database reporting
                    language"
                    <SQR-USERS@list.iex.net>


                    02/11/2002 02:37 PM
                    Please respond to
                    sqr-users






OK, this is a beginners question, and I know various answers, so I'll ask
it as a best practices question...

What's the *best* way to check if a character is numeric (0-9)in SQR?

DTH

David Thompson-Hall                                     1210 W. Dayton St.
Programmer/Analyst                                      Madison, WI 53706
Apps Tech/Operational Support Apps                      608/265-9571
Div of Info Technology (DoIT)
University of Wisconsin-Madison david.thompson-hall@doit.wisc.edu