Multiple choice technology databases

exp1 LIKE exp2 in sybase is changed to

  1. exp1 like exp2

  2. exp1 like ltrim(exp2)

  3. exp1 like rtrim(exp2)

  4. ltrim(exp1) like exp2
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Sybase behaves differently with trailing spaces in char fields. In migrations or compatibility adjustments, right-trimming the pattern (exp2) using rtrim ensures matching behavior matches expected standard patterns without trailing space mismatches.

Keep practicing — related questions