Click here to Skip to main content
14,330,041 members
Rate this:
Please Sign up or sign in to vote.
See more:
i want to validate three conditions in mobile number using sql server as follows;


The mobile number should not start with number zero.
The mobile number should not be null
The mobile number should not exceed 10 digits


The datatype is varchar.
for that how can i validate using sql query.
please help me

Rgds,
Narasiman P.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Do not re-post questions, it is against the rules of this community. Your question is still on the first page try waiting. If you want to add more information to the first question, click the "Improve question" link on it.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100