SQL question

[Peter De Berdt]

On 9 Nov 2004, at 19:25, Florian Bogeschdorfer wrote:

> Hi!
>
> I am trying to find all dates in a table which belong to a specific 
> month,
> independet from day and year (eg. Find all born in may). I have tried
> something like
>
> x=VALselectReturnCursor("SELECT * FROM KUNDENTable WHERE 
> MONTH(geburtsdatum)
> = '05'")
>
> in a 100 different ways with different positions, brackets etc, but I 
> always
> get errors like 616...
>
> Is there a solution to this?
>
Make a Method (calculation) field and use that in your query. Valentina 
does it different than other SQL dbs (personally, I prefer the other db 
way :-))



Best regards

Peter De Berdt