1 05/15/80 mrds.builtins
2
3 Function: This describes, briefly, the builtin functions avaiable to MRDS
4 database users in evaluating selection expressions.
5
6
7 Builtin funtions:
8 abs X
9 gives absolute value of X, X must be numeric.
10 after S1 S2
11 returns portion of S1 after leftmost occurrence of S2, both string types.
12 before S1 S2
13 returns portion of S1 before leftmost occurrence of S2, both string types.
14 ceil X
15 returns smallest interger >= X, X must be real.
16 concat S1 S2
17 returns the concatenation of strings S1 and S2.
18 floor X
19 returns the largest integer <= X, X must be real.
20 index S1 S2
21 returns position of leftmost occurence of S2 within S1, both string types.
22 mod X Y
23 returns X modulo Y, X and Y must be real.
24 reverse S
25 returns a string, which is the reverse of S, S must be string data type.
26 round X Q
27 returns X rounded to Q fractional digits, X real, Q integer.
28 search S1 S2
29 returns position in S1 of leftmost occurrence of any character in S2.
30 substr S I J
31 returns portion of S from Ith character, of length J.
32 verify S1 S2
33 returns position of first character of S1 that does not occur in S2.