Thats a great idea (have never written a UDF however). Probably no index
usage on this one though?
-----Original Message-----
From: Raymond Kennington [mailto:raymondk@...]
Sent: Thursday, August 22, 2002 9:25 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Calling all SQL Gurus...


Following on Martijn's idea, keep the data stored as you have and test

> EncodeDate(H.Yr, H.Mo, 12) > '2001/08/01' and EncodeDate(H.Yr, H.Mo, 12)

< '2002/07/01'

where the day 12 and >, < need to be determined according to your needs
and the
EncodeDate() is a UDF.

Raymond Kennington

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]