RE: [sqr-users] Checking for numeric datatype

["B, Ravishankar \(Cognizant\)" <Ravishankar.B@cognizant.com>]

Hi,

Try this code snippet for checking occurrence of numeric values in a
variable:

 
While #i < length($Col1)
    add 1 to #i
    Let #out = ascii(substr($Col1,#i,1))
    If not(range(#out,48,57))
       Add 1 to #status
    End-If
End-While

If #status > 0
    Let $NumFlag='F'
Else
    Let $NumFlag='T'
End-If



CHEERS !!!
Ravishankar

"Most people are only alive because it is illegal to shoot them"


-----Original Message-----
From: sqr-users-bounces+ravishankar.b=cognizant.com@sqrug.org
[mailto:sqr-users-bounces+ravishankar.b=cognizant.com@sqrug.org] On
Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Wednesday, August 30, 2006 11:15 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Checking for numeric datatype

Hi,
   Is there any function in sqr to check whether the value retireved
from the database field is a numeric or not..some thing like is
numeric..I am retrieving the database field to a variable and I need to
check whether that field is a numeric or not. Pls help
Thanks
Ram

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

This e-mail and any files transmitted with it are for the sole use of the 
intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply 
e-mail and destroy all copies of the original message.
Any unauthorized review, use, disclosure, dissemination, forwarding, printing 
or copying of this email or any action taken in reliance on this e-mail is 
strictly
prohibited and may be unlawful.

  Visit us at http://www.cognizant.com

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users