Built‑in Functions

 MID("ABCDEFGH", 2, 3) → Returns "BCD" 

- Extracts a substring starting at position 2, with length 3.  

LENGTH("Happy Days") → Returns 10 

- Counts the number of characters in the string.  

- Returns an integer value.  

LEFT("ABCDEFGH", 3) → Returns "ABC"  

- Extracts the first 3 characters from the left.  

RIGHT("ABCDEFGH", 3) → Returns "FGH"  

- Extracts the last 3 characters from the right.  

NUM_TO_STRING(78.5) → Returns "78.5"  

- Converts a number into a string.  

STRING_TO_NUM("87.5") → Returns 87.5  

- Converts a string into a number.  

INT(35.43) → Returns 35 

- Converts a decimal number into an integer by removing the fractional part.