Absulute

Thread View: borland.public.interbase.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Michael Vilhelmsen Thu, 12 Dec 2002 09:06

#11226

Author: Michael Vilhelmsen
Date: Thu, 12 Dec 2002 09:06

9 lines
1109 bytes

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

Re: Absolute

#11227

Author: Arno Brinkman
Date: Thu, 12 Dec 2002 09:48

12 lines
1219 bytes

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, use an UDF for that.

Regards,
Arno Brinkman

Re: Absolute

#11229

Author: Michael Vilhelmsen
Date: Thu, 12 Dec 2002 09:56

22 lines
1385 bytes

What is an UDF ?

Michael

"Arno Brinkman" <bnewsgroups @ abvisie.nl> skrev i en meddelelse
news:3df85bba$1@newsgroups.borland.com...
> 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, use an UDF for that.
>
> Regards,
> Arno Brinkman
>
>
>

Re: Absolute

#11230

Author: Arno Brinkman
Date: Thu, 12 Dec 2002 11:06

20 lines
1521 bytes

Hi Michael,

> What is an UDF ?

"User Defined Function" which is inside a os-library (DLL on windows).

Read the chapter "User-Defined Functions" in the language reference.


> > > 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, use an UDF for that.

Regards,
Arno

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads