Validation logic for Mobile Number Column in SQL Server
0
votes
1
answer
16972
views
I am creating a validation script and need help with mobile number validation logic with below details. Mobile number must be:
- 10 digits in length.
- Cannot begin with a 1 or a 0 (For example:1144684679 or 04468-4679
- Cannot contain all the same digit. For example: 5555555555
I am using PATINDEX for this but could not come up with the proper result.
Asked by deep kachhawa
(47 rep)
Apr 30, 2020, 09:32 AM
Last activity: Apr 30, 2020, 03:22 PM
Last activity: Apr 30, 2020, 03:22 PM