Richard,I'm not sure of the point of your first comment, could you clarify?
Quite apart from Steve's comments above, Fowler has a lengthy treatment of the uses and abuses of "that" and "which".
Thanks for the tip about Kent, I'll try and find a copy, it's certainly an area which is poorly understood both by database designers and users, compounded by completely different expectations and constraints within each group.
Pete M