At 09:55 AM 12-12-02 +0000, you wrote:

>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;

Yes. You'll need to declare the ABS() udf first though:

DECLARE EXTERNAL FUNCTION abs
DOUBLE PRECISION
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_abs' MODULE_NAME 'ib_udf';
COMMIT;

heLen