what is the use of Interval Match function ?

[mdmukramali]

Dear,

Alli.

please can anybody elobrate the functionlaity of intervalMatch function with real time scenario ?

Thanks.

[jagan]

Hi,

Suppose you have two tables

Grade          Start     End

A                 1          100

B                 101       200

C                 201       300

StudentID       Marks    

ABC                90

ACD               205

If we want to know the Grade of the Student then IntervalMatch() is very helpful in this scenario.

For example ABC marks is 90 and its Grade is A, since it falls between 1 and 100.

In this type of scenarios IntervalMatch() is useful.

You can search in the community for sample script.  There are lots of posts regarding this.

Hope this helps you.

Regards,

Jagan.