RE: [sqr-users] How to check 'CHAR' field to find out if it containsall Numeric?

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

That's very clever, but there is the risk of other characters; "@", "#",
etc.

-----Original Message-----
From: Biekens, Jan-Hein [mailto:jh.biekens@kwantum.nl]
Sent: Friday, October 15, 2004 5:16 AM
To: 'sqr-users@sqrug.org'
Subject: RE: [sqr-users] How to check 'CHAR' field to find out if it
contain sall Numeric?




A method would be:

if upper($var) = lower($var)
 ! It contains all numerics
else 
 ! It doesn't 
end-if

Regards, Jan-Hein






-----Original Message----- 
From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org 
[<mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org]On>
 Behalf Of Tajinder Chahal Sent: Thursday, October 14, 2004 3:17 PM
 To: sqr-users@sqrug.org Subject: [sqr-users] How to check 'CHAR' field to
find out if it contains all Numeric? 


Hello Everyone, We are on DB2 database.
 I need to find out if a 'CHAR' field contains all 'Numerics' or not? 



****************************************************************************
De inhoud van deze email met eventuele bijlagen is uitsluitend
bestemd voor geadresseerde en bevat mogelijk vertrouwelijke
informatie. Kennisneming, verspreiding, vermenigvuldiging of
enig ander gebruik van de inhoud van deze email door anderen
dan de geadresseerde is niet toegestaan en mogelijk strafbaar.
Indien deze email abusievelijk door u is ontvangen, wordt u
verzocht contact op te nemen met de afzender en de ontvangen
email te vernietigen.

The information contained in this mail and possible annexes is
intended solely for the use of the individual or entity to whom it
is addressed and may contain confidential information. If you
are not the intended recipient, it is prohibited and may be
unlawful to take knowledge, distribute, multiply or make any
other use of the information in this mail. If you are not the
intended recipient please notify the sender and destroy this mail.
****************************************************************************

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

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