SQL functions in where?

[Ruslan Zasukhin]

on 12/2/03 7:57 AM, Tim Davis at timdavis at amug.org wrote:

Hi Tim,

> Hi,
> 
>   Is it possible to use an SQL function in a Where clause?
> Example: SELECT field1 FROM mytable WHERE left(field1, 2) = 'ab'

Only left() works in this way.

All others must go via BaseObject methods.

In 2.0 this will be possible.


> Or, is there alternate approach to this (besides 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://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------