Thom,

Thanks for the help.

I took a different route and it appears to be working.
SELECT DISTINCT
CAST(COALESCE(LEFT(o.Part_Family_Code,2),0) AS decimal (10,2)) AS FBGM,

Thom,

Just for testing I eliminated the ISNULL

ROUND(q.Profit_Percent + cd.Commission_Percent, 2) AS "Budgeted",

This still returns the records I need (As far as...

Thanks John, I'll take a look at it.

Thanks again for your help.

John,

Thanks again.

I've been trying to find a better way to look at the FROM statement. I've always had a problem trying to determine exactly which records...

John,

I thought I had gotten it in a readable format. Thanks for showing me that it can be compacted even more.

I'm trying to determine exactly what...