Subqueries are not allowed in check constraints.
I hadn't tried this yet but i'm sure i would have figured this out quickly then =) Thanks, Jon