db2 => select name from test where 'Super tester' like name || '%'

SQL0132N  A LIKE predicate or POSSTR scalar function is not valid because the
first operand is not a string expression or the second operand is not a
string.  SQLSTATE= 42824 

db2 => select name from test

NAME
--------------------------------
Super

   1  record(s) selected.

db2 => describe table test

Column                         Type      Type
name                           schema    name               Length   Scale Nulls
------------------------------ --------- ------------------ -------- ----- ------
NAME                           SYSIBM    VARCHAR                   32       0  No

   1  record(s) selected.

db2 => SELECT name FROM test WHERE name LIKE 'Super tester%'

db2 => select name from test where 'Super tester' like name || '%'

db2 => select name from test where left('Super tester',length(name)) = name