OVERLAYB

OVERLAYB

Replaces part of a string with another string and returns the new string as an octet value.

Syntax

OVERLAYB ( input‑string, replace‑string, position [, extent ] )

Example

SELECT OVERLAYB('ABCDEFG', 'xxx', 2);

Returns: AxxxEFG