[
https://issues.apache.org/jira/browse/TRAFODION-3161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anoop Sharma updated TRAFODION-3161:
------------------------------------
Description:
OVERLAY modifies a source string by replacing a given
substring of the string, which is specified by a given numeric starting
position and a given numeric length, with a replacement string.
When the length of the substring is zero, nothing is removed
from the source string and the string returned by the function is the
result of inserting the replacement string into the source string at the
starting position.
STUFF is syntactic variation of OVERLAY.
Example:
overlay ('source original string' placing 'modified ' from 8 for 9)
stuff ('source original string', 8, 9, 'modified ')
will return:
'source modified string'
overlay ('source original string' placing 'modified ' from 8 for 0)
will return:
'source modified original string'
was:support STUFF function for SQL Server
Summary: Support ANSI OVERLAY function (was: support STUFF function)
> Support ANSI OVERLAY function
> -----------------------------
>
> Key: TRAFODION-3161
> URL: https://issues.apache.org/jira/browse/TRAFODION-3161
> Project: Apache Trafodion
> Issue Type: Sub-task
> Reporter: liu ming
> Assignee: Anoop Sharma
> Priority: Major
>
> OVERLAY modifies a source string by replacing a given
> substring of the string, which is specified by a given numeric starting
> position and a given numeric length, with a replacement string.
> When the length of the substring is zero, nothing is removed
> from the source string and the string returned by the function is the
> result of inserting the replacement string into the source string at the
> starting position.
> STUFF is syntactic variation of OVERLAY.
> Example:
> overlay ('source original string' placing 'modified ' from 8 for 9)
> stuff ('source original string', 8, 9, 'modified ')
> will return:
> 'source modified string'
>
> overlay ('source original string' placing 'modified ' from 8 for 0)
> will return:
> 'source modified original string'
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
