Date: Fri, 30 May 2008 06:28:18 -0700 (PDT)
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