> Could anybody explain me that?

30 characters is server's default length for string params. It is
used when required length cannot be derived from context. Use "LIKE
CAST(:PARAM AS VARCHAR(200))".

SY, SD.