set maximum value to a column

I have a table with a column (int type) called age. This column should hold maximun value 50. If it exceeds then it shouldn't update that row.

Means this column shold take values from 0 to 50.

If I try to update that to 51 then that shouldn't allow.

Could any one help....!

7
задан Gnanendra 2 May 2011 в 11:16
поделиться