RTRIM

1
SELECT
2
  '>' || RTRIM('Hello World   ') || '<' as trimmed;

1
SELECT
2
  price_string,
3
  RTRIM(price_string, '0') as clean_price
4
FROM (
5
  SELECT '100.5000' as price_string UNION ALL
6
  SELECT '250.1200' UNION ALL
7
  SELECT '99.0000'
8
);

1
SELECT
2
  raw_text,
3
  RTRIM(raw_text, '.,;!?') as clean_text
4
FROM (
5
  SELECT 'Hello World!!!' as raw_text UNION ALL
6
  SELECT 'How are you???' UNION ALL
7
  SELECT 'Nice to meet you...'
8
);