02-20-2008 05:49 PM
02-20-2008 06:25 PM
Why don't you want to use a math function? All it would take is a single multiply on the output of each case statement and that's hardly advanced math.
Since you have constants in the case statements, you could also just place the correct value constant in there.
For sake of argument, if you want to avoid basic math, then convert to strings, concantanate, and then convert back to numeric.
p.s Your use of the OR function makes absolutely no sense at all. There is a distinct difference between an OR and a numerical ADD.
02-20-2008 06:26 PM - edited 02-20-2008 06:27 PM
02-20-2008 06:32 PM