thanks for the replies... the value

i gave was just a sample not the actual results coming out of the query.

and it wouldn't be just 'that' value; would be applied to any value returned from

the 'percent' column.

i'm not that great with tsql, but from the looks of it the examples apply to just

one value and not the range queried ( forgive me if i misunderstand )

any how; what about truncating the 52.2027837 to something like this

52.2

any ideas?

thanks in advance