[
https://issues.apache.org/jira/browse/PHOENIX-7202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nikita Pande updated PHOENIX-7202:
----------------------------------
Description:
STRIP: [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-strip]
{*}Description{*}: The STRIP function removes blanks or another specified
character from
the end, the beginning, or both ends of a string expression.
{*}Example{*}: Remove a specific character from a string, o/p is *Hello World *
{code:java}
SELECT STRIP('---Hello World---', B, '-') AS StrippedString FROM
SYSIBM.SYSDUMMY1;
{code}
> Support STRIP operators as built in functions
> ---------------------------------------------
>
> Key: PHOENIX-7202
> URL: https://issues.apache.org/jira/browse/PHOENIX-7202
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Nikita Pande
> Priority: Major
>
> STRIP: [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-strip]
> {*}Description{*}: The STRIP function removes blanks or another specified
> character from
> the end, the beginning, or both ends of a string expression.
> {*}Example{*}: Remove a specific character from a string, o/p is *Hello World
> *
> {code:java}
> SELECT STRIP('---Hello World---', B, '-') AS StrippedString FROM
> SYSIBM.SYSDUMMY1;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
