How to validate Pan number which should not be greater than 10 digits with the help of check constraint?

Posted by vishalneeraj-24503 on 9/1/2014 | Category: Sql Server Interview questions | Views: 2761 | Points: 40

Answer:

We can write below script to validate PAN Number as:

Alter Table Employee_Master

Add Constraint CK_PAN_Number_Length

Check (Len(PAN_Number) Between 1 And 10)

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to validate Zip Code which should not exceed m ...

Next > : How to remove a Check Constraint from column in My ...

More Interview Questions by vishalneeraj-24503

Latest Interview Questions