SQL 'LIKE' comparison

Marcel J.G. Trapman marceltrapman at planet.nl
Mon Jan 20 22:01:12 CST 2003


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


Ciao,

Marcel



More information about the Valentina mailing list