Re: Removing terminal period from varchar string in table column

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

On Tue, 15 Jul 2025, Thom Brown wrote:

> UPDATE companies
> SET company_name = rtrim(company_name, '.')
> WHERE company_name != rtrim(company_name, '.');

Thom,

That makes sense. The web pages I read assumed I knew to use the UPDATE
command. As this was the first time I needed to clean column content I
didn't assume that update was the appropriate mechanism. Now I do.

Thanks,

Rich