Thanks guys, the check constrant worked. Is is possible though to have M and F come in as a drop down when doing data entry so that nothing else...

Yes that worked, thank you very much for your help. I can now start using it :).

Im afraid I dont know where to do all that, can you tell me where I need to go to do it.

I dont seem to have users/groups in my computer...

Ramesh

Could you please explain further how I go about doing that, Im afraid Im quite new to sql server. Or if I need to re-install, what I will...