OVERLAY

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Replaces a substring within a string at a specified position.

1overlay(<string> placing <replacement> from <start> for <count>)

• <string>: The original string to modify.
• <replacement>: The substring to insert.
• <start>: The starting position (1-based).
• <count>: The number of characters to replace.

Returns a text value with the specified substring replaced.

Replace characters within a string.

1SELECT overlay('Txxxas' placing 'hom' from 2 for 4) AS result;

Returns 'Thomas' by replacing 4 characters starting at position 2 with ‘hom’.

• String Types