SQL Pro Question?

[Ruslan Zasukhin]

on 1/16/04 10:12 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

> Hi
> 
> I have a DB with persons and their birth date. The birth date is of type
> kDate
> 
> Now what can I do to find all people who have birthday in MAY for example or
> in the current or next week or current or next month? I mean not in this
> year. If I search for all who have birthday in May, I need as a result e.g.:
> 
> 12.05.1978
> 16.05.1999
> 22.05.1982
> 
> Ideas ?

Hi Florian,

1) if you do this query often, and you want to have index on such kind of
query, you can make BaseObject method using function Month(f)

2) you can use LIKE search I think

    WHERE fld LIKE '../05/....'


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