That is interesting to know that SQL may not process the CTE first.  I did use a temp table instead of the CTE for this reason.  Just an interesting CTE 'flaw'.

Yes, I do have the FROM in the CTE, just didn't get it in here.

I didn't think to try to cast the int as a char.  I'll give...