> On Feb 12, 2020, at 7:09 AM, Susan Hurst
> wrote:
>
>
> I once wrote a trigger function to do just what you asked, however, it was a
> huge drain on performance so I didn't use it for long, so I dropped the
> trigger. Hopefully, someone has a more practical approach. I would be
> inte
I once wrote a trigger function to do just what you asked, however, it
was a huge drain on performance so I didn't use it for long, so I
dropped the trigger. Hopefully, someone has a more practical approach. I
would be interested in this also.
Sue
---
CCing the list.
Hello
On 2020-02-12 14:30, Pete Yunker wrote:
Shouldn’t the replacement string in regexp_replace be a single space
instead of a 0-length string?
Yes, correct.
SELECT regexp_replace(upper(trim(txt)),'[ ]{2,}', ' ', 'g') FROM test;
regexp_replace
ABC
ABC
A
Hello
On 2020-02-12 13:42, srikkanth wrote:
Hi Team,
How can i write the syntax to remove the leading spaces on a table for
all the columns.
Also, want to know how to do the all words of all the columns in
capital along with removing of leading\excessive\trailing spaces at a
time.
Can you ple
Hi Team,
How can i write the syntax to remove the leading spaces on a table for all the
columns.
Also, want to know how to do the all words of all the columns in capital along
with removing of leading\excessive\trailing spaces at a time.Can you please
help me out, let me know in case of any