Skip to main content

Caché Basic Functions

  • Abs – Returns the absolute value of a number.
  • Asc – Returns the ANSI character code corresponding to the first character in a string.
  • Atn – Returns the arctangent of a number.
  • Case – Compares a target to cases and returns the value associated with the first matching case.
  • Chr – Returns the character corresponding to the specified ANSI character code.
  • Cos – Returns the cosine of an angle.
  • Date – Returns the current system date.
  • DateAdd – Returns a date to which a specified time interval has been added.
  • DateConvert – Converts dates between internal and external formats.
  • DateDiff – Returns the number of intervals between two dates.
  • DatePart – Returns the specified part of a given date.
  • DateSerial – Returns the date for a specified year, month, and day.
  • DateTimeConvert – Converts date/time between internal and external formats.
  • Day – Returns the day of the month as an integer between 1 and 31, inclusive.
  • Derived Math Functions – The following non-intrinsic math functions can be derived from the intrinsic math functions:
  • Exists – Returns the existence status of variables and their array subnodes.
  • Exp – Returns e (the base of natural logarithms) raised to a power.
  • Fix – Returns the integer portion of a number.
  • Hex – Returns a string representing the hexadecimal value of a number.
  • Hour – Returns a whole number between 0 and 23, inclusive, representing the hour of the day.
  • Increment – Atomically increments the value of a variable and returns the new value.
  • InStr – Returns the position of the first occurrence of one string within another.
  • InStrRev – Returns the position of the first occurrence of one string within another, searching from the end of string.
  • Int – Returns the integer portion of a number.
  • IsObject – Returns a value indicating whether an expression references a valid Automation object.
  • Join – Returns a string created by joining a number of array elements.
  • LCase – Returns a string that has been converted to lowercase.
  • Left – Returns or replaces a specified number of characters from the left end of a string.
  • Len – Returns the number of characters in a string or the number of bytes required to store a variable.
  • List – Returns elements from a list.
  • ListBuild – Creates a list of elements.
  • ListExists – Indicates whether an element is present in the list and has a value.
  • ListFind – Finds an element in a list.
  • ListFromString – Creates a list from a string.
  • ListGet – Returns an element from a list.
  • ListLength – Returns the number of elements in a list.
  • ListNext – Retrieves elements sequentially from a list.
  • ListSame – Compares two lists and returns a boolean value.
  • ListToString – Creates a string from a list.
  • ListValid – Determines if an expression is a list.
  • Lock – Obtains a logical lock on a variable name.
  • Log – Returns the natural logarithm of a number.
  • Mid – Returns or replaces a specified number of characters from a string.
  • Minute – Returns a whole number between 0 and 59, inclusive, representing the minute of the hour.
  • Month – Returns the month of the year as an integer between 1 and 12, inclusive.
  • MonthName – Returns a string indicating the specified month.
  • Now – Returns the current date and time according to the setting of your computer's system date and time.
  • Oct – Returns a string representing the octal value of a number.
  • Piece – Returns the specified substring, using a delimiter.
  • Replace – Returns a string in which a specified substring has been replaced with another substring a specified number of times.
  • Right – Returns or replaces a specified number of characters from the right end of a string.
  • Rnd – Returns a random number.
  • Round – Returns a number rounded to a specified number of decimal places.
  • Second – Returns a whole number between 0 and 59, inclusive, representing the second of the minute.
  • Sgn – Returns an integer indicating the sign of a number.
  • Sin – Returns the sine of an angle.
  • Space – Returns a string consisting of the specified number of spaces.
  • Split – Returns a zero-based, one-dimensional array containing a specified number of substrings.
  • Sqr – Returns the square root of a number.
  • StrComp – Returns a value indicating the result of a string comparison.
  • String – Returns a repeating character string of the length specified.
  • StrReverse – Returns a string in which the character order of a specified string is reversed.
  • Tan – Returns the tangent of an angle.
  • Time – Returns the current system time.
  • TimeConvert – Converts time between internal and external formats.
  • Timer – Returns the number of seconds that have elapsed since midnight UTC.
  • TimeSerial – Returns the time for a specific hour, minute, and second.
  • Traverse – Traverses an array and returns the next subscript.
  • LTrim, RTrim, and Trim – Returns a copy of a string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim).
  • UCase – Returns a string that has been converted to uppercase.
  • Unlock – Releases a logical lock on a variable name.
  • Weekday – Returns a whole number representing the day of the week.
  • WeekdayName – Returns a string indicating the specified day of the week.
  • Year – Returns the year as a four-digit integer.
FeedbackOpens in a new tab