SQL 'LIKE' comparison

[Marcel J.G. Trapman]

Looking at the docs of valentina I conclude the following:

normal SQL LIKE 'test'...
Valentina = LIKE 'test'...   search for all string containing 'test'

normal SQL LIKE '%test'...
Valentina = LIKE 'test\Z'...   search for all strings that end with 
'test'

normal SQL LIKE 'test%'...
Valentina = LIKE '\Atest'...   search for all string that begin with 
'test'

Is this the right interpretation AND why is this different than 
'normal'? SQL

Ciao,

Marcel