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

["Tajinder Chahal" <Tchaha@Roushind.com>]

Thanks a lot Kevin.

I found out that it is other way around
if $string <> '' and translate($string, '','0123456789') = ''

>>> kevin.reschenberg@sparkpath.com 10/14/04 04:34PM >>>
if $string <> '' and translate($string, '0123456789', '') = ''
   ! It contains all numerics
else
   ! It doesn't

Kevin Reschenberg
SparkPath Technologies, Inc.

www.sparkpath.com 

 
-------- Original Message --------
Subject: [sqr-users] How to check 'CHAR' field to find out if it
contains all Numeric?
From: "Tajinder Chahal" <Tchaha@Roushind.com>
Date: Thu, October 14, 2004 1:16 pm
To: sqr-users@sqrug.org 

Hello Everyone,

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


_______________________________________________
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


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