Hello Christian,

CB> I have a table with the name as varchar and the birthday as date.

CB> And now a simple question: how can a get with a simple SQL statement the
CB> name of the people, who will have birthday within the next 14 (for
CB> example) days. Is it possible to do this in a single SQL statement?

CB> The question is easy, but the solution not, correct?

Have you tried
-----
select Name, BirthDate from Persons
where BirthDate between :Dt and :Dt + 14;
-----

--
Best regards,
Pavel Menshchikov
http://www.ls-software.com/