Hi,

> Correct, but it made a simple query :-)

That very usefull too :)

> By looks he wants a years worth of data, my query will require the server

to

> serve 2 years worth of data to the query engine instead of the exact

period.

>
> I'm sure his DB would be better with a date field in it rather than two
> fields or even a yyyymm integer field.

My bet there too.

> Have a good weekend.

Same to you.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."