Re: To function or not to function, that is the question at hand

[Alan Campin <alan0307d@xxxxxxxxx>]

You are querying AS/400 data? If yes, go to
www.think400.dk/downloads.htmand get iDate. You will be able just say
iDate(YourField) and then treat as
a date data type. Don't know about more efficient. Might be and might not.

On Wed, Feb 9, 2011 at 2:39 PM, Mike Wills <mike@xxxxxxxxxxxxxx> wrote:

> I am working on some SQL statements for an ASP.NET application. One of the
> things that is required is to only display information in an open period.
> The period is updated automatically by the vendor software as the previous
> period is closed. So I finding myself doing a bunch of sub selects like:
>
>  where date >= (SELECT DATE(CONCAT('20', CONCAT(YY, CONCAT('-', CONCAT( MM,
> (CONCAT('-', DD))))))) FROM LIB/FILE')
>
> Yes, each portion of the date is in separate fields.
>
> Would making this query a function make the query more efficient? I have
> never created a function before how would I do that? My thought is having
> something like:
>
> IsInRange(date)
>
> So I can do "WHERE IsInRange(date)".
>
> Or is there a better way?
>
> --
> Mike Wills
> http://mikewills.me
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.