Sample Header Ad - 728x90

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