----- Original Message -----
From: "Adomas Urbanavicius" <adomas@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, March 14, 2006 3:47 PM
Subject: Re: [firebird-support] only for numerics...
>>>>Thanks Adomas,
>
>>>>I had thought about that too, though it would mean generating a SP for
>>>>each
>>>>field... and I think it's hardly feasible in my situation.
>
> Not generating SP for each field, but rewriting you sql select query with
> SP :
> if it was
> where
> my_year > 1975
> my_week > 45
> my_age > 25
> my_weight > 125
> it would be
> where
> (SELECT MY_NUMERIC FROM MY_SP( my_year )) > 1975
> AND
> (SELECT MY_NUMERIC FROM MY_SP( my_week )) > 45
> AND
> (SELECT MY_NUMERIC FROM MY_SP( my_age )) > 25
> AND
> (SELECT MY_NUMERIC FROM MY_SP( my_weight )) > 125