Thanks for both of your replies, however none above work. I've written 1) ALTER TABLE Players SET CHECK datediff(y,DOB,getdate()) >=16; >>>>>DONT WORK
2) ALTER TABLE Players SET CHECK DOB >= dateadd(y,-16,getdate()); And the error i get is 'missing UNUSED keyword'
I wanted to know, could this be the problem, I've writen the values for Date of Birth as '14-JUN-1991' >>>Is that why its not working. Instead, should I write it as '14/06/1991'
However if I write it as '14/06/1991' on SQL, that wont work (Just tested it) and it gives me an error "not a valid month" NOTE: The DOB field datatype is 'DATE' not 'NUMBER' Please give your suggestions. Thank you again