All Articles

Index

Years

%YEARS converts a number into a duration that can be added to a date...

Xlate

The string is translated by %XLATE based on the values of startpos, from, and...

Xfoot

The total of each element in the given numeric array expression is produced by...

Upper

%UPPER returns the string operand, with all or part of the operand converted to...

Uns

The expression’s value is converted to unsigned format using %UNS. Any decimal digits are...

Trimr

The %TRIMR function is used to remove a string’s trailing blank spaces. Other than...

Triml

The %TRIML method is used to remove a string’s leading blank spaces. Other than...

Trim

To remove blank space from a string on both sides, use the %TRIM function....