Re: Help : Removal of leading spaces in all the columns of a table

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

---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan(dot)hurst(at)brookhurstdata(dot)com
Mobile: 314-486-3261

On 2020-02-12 06: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 leadingexcessivetrailing spaces at a time.
>
> Can you please help me out, let me know in case of any inputs.
>
> Thanks,
>
> Srikanth B