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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of
1.18 million developers, IT pros, digital marketers,
and technology enthusiasts learning and sharing knowledge.