RE: [sqr-users] Checking for numeric datatype

["Kaithi, Murali" <Murali.Kaithi@spencergifts.com>]

Move $var to #var
If #var >= 0
 let $is_numeric = 'T'
Else
 let $is_numeric = 'F'
End-if

Murali.. 

-----Original Message-----
From: sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org
[mailto:sqr-users-bounces+murali.kaithi=spencergifts.com@sqrug.org] On
Behalf Of Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Wednesday, August 30, 2006 1:57 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Checking for numeric datatype

the table is a custom table thats built for a specific purpose to hold
certain transactions. its not a oracle provided table.

-----Original Message-----
From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org
[mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org]On
Behalf Of Knapp, Richard
Sent: Wednesday, August 30, 2006 1:53 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Checking for numeric datatype



Describe the source table.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Wednesday, August 30, 2006 12:45 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

_______________________________________________
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

________________________________________________________________________
This Email has been scanned for all viruses by PAETEC Email Scanning Services, 
utilizing MessageLabs proprietary SkyScan infrastructure. For more information 
on a proactive anti-virus service working around the clock, around the globe, 
visit http://www.paetec.com.
________________________________________________________________________

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