<http://schema.org/articleBody>
"Robert, Your first two whens can be combined into one WHEN Number_Deleted_Rows = 0 THEN 0 Also, your very last when doesn't return 'Percent deleted', consider 1 Row and 5 deleted. Returns 20%. The more deleted the smaller the percent, is that what you really want? You may be able to use the when before that as an ELSE catchall. Scott Mildenberger Programmer/Analyst Davis Transport Inc. Missoula, MT 406-728-5510 x128 -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201309/msg00628.html>