Regular Expression

From: <>
Date: Fri, 30 May 2008 06:28:18 -0700 (PDT)
Message-ID: <>


We have these expressions in our queries: A + B / C .......

What they want is if any of the numbers are -99999 they should be converted to a 0. If they are all -99999 then the result of the entire expression should be -99999.

Rather than creating a function where I pass it in as a string and parse it, I'm trying to see if I can use a regular expression to do some counting alone with a decode or case to do this........

Thanks! Received on Fri May 30 2008 - 08:28:18 CDT

Original text of this message