If it is a Retail XP Professional CD, barring a licensing issue, there is not a problem using this to upgrade XP Home. The XP Upgrade CD was offered as a lower cost alternative to the Full license.
But, there are XP CDs and there are XP CDs. See my faq: faq779-4004