Hello TIA,

What I use is a stored proc which can do a number of different searches, but it is a rather large routine because of the number of...

Maybe this does help  :

Two rows A and B overlap when :
(A.stop > B.start   AND   B.stop > A.start)

But there is plenty of situations which maybe...

Hallo All,

Some years ago I wrote a 'replace2' function which can do multiple replaces in one go.
It does the same job as a multiple nested replace, but...

Using fractions like 1/3 or even 1/10 is always risky when using float calculations. Both 1/3 and 1/10 are not exactly presented in most binairy systems.

A1, A2, B1,...

Sorry for the confusion,  I should have paid more attention to the situation. (English is not my first language, so although I do check the things that I have written....

First of all, everybody thanks for participating.

I came up with the next 2 sets of code:
The first set is more compact and can handle longer views.
The...

Hallo Jonathan and Subramaniam,

I am monitoring what the effect of a table insert/update/delete has on a View.
From the view definition it is possible to determine which fields...