Yes, use the UDF lib supplied:

/*****************************************
*
* a b s
*
*****************************************
*
* Functional description:
* Returns the absolute value of a
* number.
*
*****************************************/
DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';

-----Original Message-----
From: Michael Vilhelmsen <Michael.Vilhelmsen@...>
[mailto:Michael.Vilhelmsen@...]
Sent: 12 December 2002 09:56
To: ib-support@yahoogroups.com
Subject: [ib-support] ABS


Hi

Is it posible to make a select where I wants an absolute value in my
where
statement ?
Something like this:

Select * from MyTable where ABS(MyField)>1;

Michael




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/