Multiple choice technology programming languages

STRIP(string) returns the same result as :

  1. TRIMN(LEFT(string))

  2. TRIM(LEFT(string))

  3. TRIMN(RIGHT(string))

  4. TRIM(RIGHT(string))
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

STRIP() removes both leading AND trailing blanks from a string. LEFT() left-justifies the string (removes leading blanks only). TRIMN() removes trailing blanks without converting the result to a null string if all blanks. Therefore TRIMN(LEFT(string)) first left-justifies, then removes trailing blanks - equivalent to STRIP. TRIM(LEFT) would also work but TRIMN is the precise match because STRIP also doesn't convert to null.

Keep practicing — related questions