using wildcards and week() in V1

[Ruslan Zasukhin]

On 10/15/06 10:33 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

> And why does this not work (error 616):
> 
> select geburtsdatum from kundentable where week(geburtsdatum,1)=7

const long errSQL_WrongExpression        = 616;


All I can say -- try check docs about week function,
Although all looks fine..

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]