Subject RE: [ib-support] Calling all SQL Gurus...
Author Kevin Stanton
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
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:

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

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