LEN('hello'): 5 (expected: 5)LEFT('hello', 3): hel (expected: hel)RIGHT('hello', 2): lo (expected: lo)MID('hello', 2, 3): ell (expected: ell)INSTR('hello world', 'world'): 7 (expected: 7)INSTRREV('hello hello', 'hello'): 7 (expected: 7)REPLACE('hello world', 'world', 'there'): hello thereTRIM(' hello '): 'hello' (expected: 'hello')LTRIM(' hello'): 'hello' (expected: 'hello')RTRIM('hello '): 'hello' (expected: 'hello')LCASE('HELLO'): hello (expected: hello)UCASE('hello'): HELLO (expected: HELLO)SPACE(5): ' ' (expected: 5 spaces)STRING(3, 'x'): xxx (expected: xxx)STRREVERSE('hello'): olleh (expected: olleh)STRCOMP('abc', 'abc'): 0 (expected: 0)STRCOMP('abc', 'def'): -1 (expected: -1)ASC('A'): 65 (expected: 65)CHR(65): A (expected: A)HEX(255): FF (expected: FF)OCT(8): 10 (expected: 10)
ABS(-42): 42 (expected: 42)SQR(16): 4 (expected: 4)ROUND(3.7): 4 (expected: 4)ROUND(3.14159, 2): 3.14 (expected: 3.14)INT(3.9): 3 (expected: 3)INT(-3.9): -4 (expected: -4)FIX(3.9): 3 (expected: 3)FIX(-3.9): -3 (expected: -3)SGN(-5): -1 (expected: -1)SGN(0): 0 (expected: 0)SGN(5): 1 (expected: 1)SIN(0): 0 (expected: 0)COS(0): 1 (expected: 1)TAN(0): 0 (expected: 0)LOG(1): 0 (expected: 0)EXP(0): 1 (expected: 1)RND(): True (expected: True)ATN(0): 0 (expected: 0)
YEAR(NOW()): 2026MONTH(NOW()): 1DAY(NOW()): 17HOUR(NOW()): 22MINUTE(NOW()): 58SECOND(NOW()): 37WEEKDAY(NOW()): 7 (1=Sunday to 7=Saturday)TIMER(): 82717 (seconds since midnight)WEEKDAYNAME(1): Sunday (expected: Sunday)MONTHNAME(1): January (expected: January)TIME(): 1899-12-30 22:58:37 -0300 -03DATE(): 2026-01-17 00:00:00 -0300 -03
CINT('42'): 42 (expected: 42)CDBL('3.14'): 3.14 (expected: 3.14)CSTR(42): 42 (expected: 42)CBOOL(1): True (expected: True)CBOOL(0): False (expected: False)CBYTE(255): 255 (expected: 255)CCUR(19.99): 19.99 (expected: 19.99)CLNG(42): 42 (expected: 42)CSNG(3.14): 3.14
ISEMPTY(Empty): True (expected: True)ISNUMERIC('42'): True (expected: True)ISNUMERIC('hello'): False (expected: False)ISDATE('01/01/2020'): True (expected: True)ISARRAY(ARRAY(1,2,3)): True (expected: True)ISOBJECT(CreateObject('G3JSON')): False (expected: True)
FORMATCURRENCY(19.99): $19.99FORMATCURRENCY(19.9, 1): $19.9FORMATNUMBER(3.14159, 2): 3.14FORMATPERCENT(0.75, 0): 75%
RGB(255, 0, 0): 255 (expected: 255 for red)RGB(0, 255, 0): 65280 (expected: 65280 for green)RGB(0, 0, 255): 16711680 (expected: 16711680 for blue)
Test completed at: 2026-01-17 22:58:37.3572652 -0300 -03 m=+2.180584401