TRUNC Function

Parameters (String, Integer);

Returns: String;

Function to truncate a string to a maximum length.

The first parameter is the source string.

The second parameter is maximum length of the returned string.

If the string is not longer than <length> it will be returned unchanged.

If the string NULL it will be returned unchanged.

Example:  TRUNC('Hello World',8) = 'Hello Wo'