SQL question // LIKE on date

[Florian Bogeschdorfer]

> 
> 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/????'
> 
> 
OK. I am glad, my brain still works. I was already thinking of retirement...

Best regards, Florian