Re: Removing terminal period from varchar string in table column

[Rich Shepard]

On Tue, 15 Jul 2025, Thom Brown wrote:

There are various options, but perhaps just use rtrim.
rtrim(company_name, '.')

Thom,

I looked at rtrim() but didn't see where to specify the table name. Would it
be `select * from table companies rtrim(company_name, '.')'?

Thanks,

Rich