LTRIM

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

1
SELECT
2
  product_code,
3
  LTRIM(product_code, '0') as clean_code
4
FROM (
5
  SELECT '000123' as product_code UNION ALL
6
  SELECT '00456' UNION ALL
7
  SELECT '0007'
8
);

1
SELECT
2
  raw_value,
3
  LTRIM(raw_value, '$#') as clean_value
4
FROM (
5
  SELECT '$$$100' as raw_value UNION ALL
6
  SELECT '###200' UNION ALL
7
  SELECT '$#$300'
8
);