It's the kind of thing you can either do through partitioning, or through moderately complex triggers, or through indirect means in the data design.
In your case, a vertically partitioned table might be the best bet. You can look those up online pretty easily.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon