SQL Search for records that BEGIN WITH

[Ivan Smahin]

On 8/21/2011 9:52 PM, rb at teknia.com wrote:
> Apparently Valentina does nto have a BEGISN WITH operator.
>
>

SELECT  * FROM t1 WHERE LEFT(f1,  2) = 'Pp';

http://www.valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:funcs_string#left_str_len

-- 
Best regards,
Ivan Smahin
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20110822/c81b8a76/attachment.html>