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: 307 | 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 

Comments or Responses

Login to post response