SQL 'LIKE' comparison

Mon Jan 20 22:51:05 CST 2003

on 1/20/03 10:39 PM, Marcel J.G. Trapman at marceltrapman at planet.nl wrote:

> 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

In 2.0 will be made norlam LIKE and current "LIKE" will be renamed to REGEX.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------