[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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

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