SQL question // LIKE on date

[Ruslan Zasukhin]

On 11/12/04 10:46 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

> Good morning Ruslan!
> 
> Let's first finish the LIKE thing.

FLORIAN,

I have check and really LIKE do not accept Date field.
I have made String field and enter date formated string.
Now LIKE works.

Strange because I was sure that LIKE do accept Date Time fields also.
And numeric...may be something is broken.

So may be only way -- to use String method that simply = fldDate


Ivan, please make sure that in 2.0 tests we have such tests
    WHERE fldDate LIKE '??/07/????'


> I have a fld kTypeDate
> You say "." is a RegEx control character and is a placeholder for any
> character?
> 
> Now if I have a record with fld="12.07.2004" why wouldn't it find it
> searching with fld LIKE "12.07.2004". Since "." is a placeholder it should
> find the dots in "12.07.2004" as well as a field like "12?07!2004"? NOT?
> 
> And why does fld LIKE ".........." does return an empty cursor? Why does it
> not find ALL dates?

-- 
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
-------------------------------------------------------------