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.hu...@brookhurstdata.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