Multiple choice technology databases

Trim('0' from 000435600 )?

  1. 435600

  2. 0004356

  3. 00043560

  4. 4356
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

TRIM with a specific character removes all leading AND trailing occurrences of that character. TRIM('0' FROM '000435600') strips zeros from both ends: the three leading zeros and the two trailing zeros all get removed, leaving '4356'. Option A only stripped leading zeros; options B and C left trailing zeros; only option D shows correct removal from both ends.

Keep practicing — related questions