Multiple choice technology platforms and products

What is the output of the LTRIM(‘SCARES’,’S’)

  1. CARES

  2. SCARES

  3. CARE

  4. SCARE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

LTRIM('SCARES', 'S') removes all occurrences of 'S' from the LEFT side of the string until a non-'S' character is encountered. The first character 'S' is removed, giving 'CARES'. Note that LTRIM removes characters from a set, not a substring - it would remove multiple leading S's if present.

Keep practicing — related questions